Freeze Panes Using the Active Cell
When you activate Freeze Panes in Excel, all the rows above the active cell and all the columns to the left of the active cell become frozen.
To freeze only those columns and rows you want to stay on screen, click on the cell to the right of the columns and just below the rows that you want to remain on screen.
For example - to keep rows 1,2, and 3 on the screen and columns A and B, click in cell C4 with the mouse. Then choose Window > Freeze Panes from the menu, as shown in the image above.
Want some more help?
Next, is a short step by step example showing you how to use the freeze feature in Microsoft Excel.
