If you are working on a large spreadsheet where all the rows and columns of data don’t fit on the screen, it would be helpful to be able to keep the heading rows and columns stationary so you can scroll through the data.
You can freeze rows and columns in your spreadsheet. To do so, select the cell above which and to the left of which you want to freeze the columns and rows.
Click the View tab.
Click Freeze Panes in the Window section of the View tab and select Freeze Panes from the drop-down menu.
You can now scroll through the data while the heading rows and columns stay still, as pictured in the first image in this article.
NOTE: Frozen rows and/or columns are indicated by a thin black border.
To allow the frozen rows and columns to move again, click Freeze Panes in the Window section of the View tab and select Unfreeze Panes.
You can also just freeze rows or columns. For example, to freeze the header row for a long table, select a cell below the row(s) you want to freeze.
Click Freeze Panes in the Window section of the View tab and select Freeze Top Row.
Now the heading row(s) will stay in place as you scroll through your data.
This feature is very handy for viewing long, complicated spreadsheets.
- Published 06/27/13