How to Freeze Columns
Excel spreadsheets store numbers, dates and currency in tables consisting of rows and columns. Because Excel documents are designed to hold a large amount of information, row labels may become hidden from view when you scroll to the right to view the later columns in a spreadsheet. You must then scroll back to see which row of data you are looking in. If you freeze the column containing the labels, they will remain on the screen regardless of how far you scroll away.
Other People Are Reading
Instructions
-
Microsoft Excel 2010
-
1
Click the letter for the column directly to the right of the column you want to freeze. This selects the entire column.
-
2
Click the "View" tab.
-
-
3
Click "Freeze Panes," then choose "Freeze Panes" from the drop-down menu.
OpenOffice Calc
-
4
Click the letter for the column directly to the right of the column you want to freeze. This selects the entire column.
-
5
Click "Window" on the top menu.
-
6
Select "Freeze" from the list.
-
1
