Freeze Panes Using the Active Cell
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.