Freeze Panes

If you would like Rows (at the top) or Columns (at the left) of your spreadsheet to remain visible while scrolling you can “freeze” them.

For instance, if Row 1 contains column headings and your screen view requires scrolling, you may want to be able to see the headings regardless of how far you scroll.

In the following picture Row 1 contains my headings and is frozen. I have also scrolled to Row 150. Notice that my headings are still visible:

freeze panes

Freezing Rows

Select the Entire Row Below the rows to Freeze and on the main menu select Window->Freeze Panes. This will Freeze all of the rows above your selection.

Freezing Columns

Select the Entire Column to the right of the Columns to Freeze and on the main menu select Window->Freeze Panes. This will Freeze all of the Columns to the left of your selection.

Freezing Rows and Columns

Select the first Cell below the Rows and to the right of the Columns to Freeze and on the main menu select Window->Freeze Panes. This will Freeze all of the rows above your selected Cell and all of the Columns to the left.

View how to Freeze Panes using VBA.

Leave a Comment