Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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. |
#4
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) |