Excel Headers while scrolling down
 

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

"Tavish Muldoon" wrote:

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.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Tavish Muldoon" schrieb im Newsbeitrag
om...
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.

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

"Tavish Muldoon" wrote in message
om...
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.