Freeze rows or columns
Sometimes you want to freeze certain rows or columns or even an area in Excel sheet that you do not want to move while scrolling the sheet on left, right, up or down. Here is what you need to do - The Freeze Pane feature!
Freeze the first column
Select View > Freeze Panes > Freeze First Column.
The faint line that appears between Column A and B shows that the first column is frozen.
Freeze the first two columns
Select the third column.
Select View > Freeze Panes > Freeze Panes.
Freeze columns and rows
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
Select View > Freeze Panes > Freeze Panes.
