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:
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.
August 14th, 2008 at 3:43 pm
[...] recently posted on Freezing panes in Excel, here’s how you can do it using [...]