Freeze Rows and Columns in a List in Excel

Question

How do I freeze rows and columns in a list in Excel?

Answer

When you scroll through large amounts of data in a worksheet, you can move data off the screen. If you prefer to have portions of data remain on the screen at all times, such as the column and/or row headings, you can freeze a portion of the list so that it remains while the rest of the data scrolls.                                                                            

To freeze rows and columns:

1. Click in a cell to select it,
2. Select the Window group from the View tab,
3. Click on Freeze Panes.

 
Excel will display dark vertical and horizontal lines to indicate the rows and columns that are frozen.
 

For more information about Charts and Graphs in Excel, please view the full tutorial from the CTL here: Excel Part 2

If you need further assistance, please click the CTL Support Request button on this page.