How do you make the heading of columns stay their while you scroll the rest
of information up and down?

WindowFreeze Panes

"wavetoall" wrote:

How do you make the heading of columns stay their while you scroll the rest
of information up and down?

Click on the row header 2 (left side of worksheet)
Use Windows|Freeze Panes
Now when you do vertical scroll row 1 is always visible
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"wavetoall" wrote in message
. ..
How do you make the heading of columns stay their while you scroll the
rest of information up and down?

Hi!

If your headers are in row 1, starting in cell A1....

Select cell A2
Goto WindowFreeze Panes

Biff

"wavetoall" wrote in message
. ..
How do you make the heading of columns stay their while you scroll the
rest of information up and down?

Thanks to all for the response and helping me. I have another question, can
one make the first row be zero or nothing so that the second row is one?

"Biff" wrote in message
...
Hi!

If your headers are in row 1, starting in cell A1....

Select cell A2
Goto WindowFreeze Panes

Biff

"wavetoall" wrote in message
. ..
How do you make the heading of columns stay their while you scroll the
rest of information up and down?