Excel2010 Frozen window graphics and text tutorial
Using the freeze feature of the Excel worksheet to achieve a fixed window, let's take a look at the specific steps of this approach:
Excel2010 How to freeze window steps/Methods
Open the Excel worksheet, and if you want to freeze the "A1" line, then we're going to select the "A2" cell
On the menu bar, click the View tab
In the Window option group, click the arrow button for Freeze window
Open Menu click the "Freeze Splitter Pane" command
Now in the Excel interface, we can see that the "A1" line has one more line underneath it, which is the frozen state.