make heading column stationary
 

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

make heading column stationary
 

WindowFreeze Panes

"wavetoall" wrote:

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

make heading column stationary
 

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?

make heading column stationary
 

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?

make heading column stationary
 

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?