Excel Headers while scrolling down

  • Thread starter Thread starter Tavish Muldoon
  • Start date Start date
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.
 
They won't "float" but you could:
Click in cell A2 (or, one cell below your first heading).
Then, Windows | Freeze Panes.

tj
 
Hi
- move the cursor in the row BELOW of your header
- goto 'Windows - Freeze Panes'
 
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
 
Back
Top