How to keep colunm headings when scrolling down in excel
 

When using an excel worksheet I put my own headings for columns in row #1.
When I scroll down too far I lose those headings. Is there a way to keep them
at the top of the screen?

Hi,

Highlight the 2nd row and click on WINDOWS -- FREEZE PANES.

Hope that helps

--
Joham


Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

select row 2 and do Window=Freeze panes

with any cell selected you can do Window=UnFreeze panes
to reverse it.

if you selected B2 and then did it, row1 and column 1 would be "frozen"

it freezes to the left and above the current selection.

--
Regards,
Tom Ogilvy

"Oliver" wrote in message
...
When using an excel worksheet I put my own headings for columns in row #1.
When I scroll down too far I lose those headings. Is there a way to keep
them
at the top of the screen?