Excel Headers while scrolling down

T

Tavish Muldoon

Hello,

I have a huge spreadsheet with many header columns. As I scroll down
the spreadsheet, I come to certain columns and am not sure what they
are. So I have to scroll all the way back up - see the column name,
then go back to my original spot.

Is there a way to make the column names 'float' on top of every page -
so the headers are always visible?

Thanks,

Tmuld.
 
G

Guest

They won't "float" but you could:
Click in cell A2 (or, one cell below your first heading).
Then, Windows | Freeze Panes.

tj
 
F

Frank Kabel

Hi
- move the cursor in the row BELOW of your header
- goto 'Windows - Freeze Panes'
 
P

Paul B

Tavish, click in the row below your headers and then go to window freeze
panes
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top