1. Computing

Excel Freeze Panes Step by Step Tutorial

By

4 of 5

Freeze Both Columns and Rows
Freeze Both Columns and  Rows

Freeze Both Columns and Rows

© Ted French

Freeze Panes Using the Active Cell

The Freeze Panes option freezes all the rows above the active cell and all the columns to the left of the active cell.

To freeze only those columns and rows you want to stay on screen, click on the cell to the right of the columns and just below the rows that you want to remain on screen.

Example of freezing panes using the active cell

To keep rows 1, 2, and 3 on the screen and columns A and B:

  1. Click in cell C4 with the mouse to make it the active cell.

  2. Click on the View tab.

  3. Click on Freeze Panes from the ribbon to open the features drop down list.

  4. Click on Freeze Panes option in the list.

  5. A black border should appear to the right of column B in the worksheet and below row 3 indicating that the areas above and to the right of the lines have been "frozen".

  6. Scroll to the right in the worksheet. If you scroll far enough, the columns to the right of column B will begin disappearing while columns A and B will stay on the screen.

  7. Scroll down through the worksheet. If you scroll far enough, the rows below row 3 will begin disappearing while rows 1, 2, and 3 will stay on the screen.

©2014 About.com. All rights reserved.