How to Freeze Panes in Excel 2010?
To freeze panes, you can keep specific rows or columns visible when you scroll in the worksheet. For example, you can view distant parts of the worksheet while the headings remain in place.
Follow these steps to freeze panes in a worksheet:
A. Select the cell cursor based on what you want to freeze:
- Columns: Select the column to the right of the columns you want to freeze. For example, click any cell in column B to freeze column A.
- Rows: Select the row below the rows you want to freeze. For example, click any cell in row 4 to freeze rows 1, 2, and 3.
- Columns and rows: Click the cell below the rows and to the right of the columns you want to freeze — essentially, the first cell that isn't frozen. For example, click cell B2 to freeze both column A and row 1.
B. Go to the Ribbon, click the "View" tab >>> "Windows" group >>> "Freeze Panes".
C. Go to the Ribbon, click the "View" tab >>> "Windows" group >>> "Unfreeze Panes".
Kutools for Excel
More than 100 Advanced Functions for Excel 2007 and 2010
