Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to show column titles when scolling down 2

Status
Not open for further replies.

CFNB

Programmer
Feb 15, 2007
36
CA
Hello.

I have a very long excel document. When I scroll down (or go to the last record), I lose my column titles. I know there is a way to always show them on the screen, but I cannot find it.

Thanks in advance.
 
Look at the Window Menu - split or freeze panes options.

Regards

Fen
 
Hello

I think from your probelm, unless i have misread, that you need to use the freeze panes function. Click in the cell leftmost and 1 below where your titles are (so if your column titles is a1 you would click in b1) and then Go to Window, then freeze pains. This will lock your titles in place.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top