How to Use Freeze Frames in Excel

Microsoft Excel allows users to freeze specific rows and/or columns so that the data contained within the cells is always visible. This is very advantageous in large spreadsheets that have hundreds or even thousands of entries. The user may choose to freeze the first row so the labels for each of the entries is visible, even if the spreadsheet has been scrolled down to the last entry.

...
Microsoft Excel gives users total control over how spreadsheets are controlled onscreen.

Step

Open an Excel spreadsheet with some data.

Step

Choose which rows and/or columns to freeze. To freeze rows only, select the row immediately beneath the row or rows you want to remain visible. To freeze columns only, select the column immediately to the right of the column or columns you want to remain visible. To select both rows and columns, select the cell immediately below and to the right of the row and column you want to remain visible.

Step

Click the "Window" menu in Excel 2003. Click the "View" tab in Excel 2007/2010.

Step

Click "Freeze Panes" in Excel 2003 to complete the process. Click the "Freeze Panes" option with the down arrow and continue to the next step in Excel 2007/2010.

Step

Select "Freeze Panes" from the drop-down menu in Excel 2007/2010 to complete the process.