Freeze the side column/top row & scroll others

[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)

 

[Dennis Tucker]

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

 

[Teethless mama]

Select B2 > Window > Freeze Panes