Freeze the side column/top row & scroll others
 

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 the side column/top row & scroll others
 

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

"goadk123" wrote in message
...
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 the side column/top row & scroll others
 

Select B2 Window Freeze Panes


"goadk123" wrote:

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)