Freeze the side column/top row & scroll others

  • Thread starter Thread starter goadk123
  • Start date Start date
G

goadk123

what is the function to set (lock in or freeze) the first column and / or top
row
of a spreadsheet, so the words and numbers remain in the same place as you
scroll the other columns and rows.
(so you can add more columns..yet keep the main information in the first
column/row)
 
Freeze Panes.....

In older versions of Excel, it is under Window.
In 2007 version of Excel, it is under View.

You first select a cell, then activate the command. Excel uses the selected
cell's upper left corner to define the freeze point.

Play with it. You can also Unfreeze panes that were frozen before.

Dennis
 
Back
Top