Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
always visable header row
Hello All- I have seen this before and I have been trying to figure it out
for months. How can I create a header row that is always visable as I scroll down the rest of m sheet? Like I can always see row 1 and it always meets up with the information in each column rather I am looking at row 2 or row 2005. Make sense? THANKS! I'd really appreciate any help, this has been driving me crazy and no one at work knows what I am talking about. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
always visable header row
Select A1 (just so you can see it)
select A2 Window|Freeze Panes (in xl2003) Everything above the activecell and to the left of that activecell will be frozen. If you have data|filter|autofilter applied, show all the data before you freeze panes. Angee wrote: Hello All- I have seen this before and I have been trying to figure it out for months. How can I create a header row that is always visable as I scroll down the rest of m sheet? Like I can always see row 1 and it always meets up with the information in each column rather I am looking at row 2 or row 2005. Make sense? THANKS! I'd really appreciate any help, this has been driving me crazy and no one at work knows what I am talking about. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
always visable header row
THANK YOU THANK YOU THANK YOU!!! It worked!
"Dave Peterson" wrote: Select A1 (just so you can see it) select A2 Window|Freeze Panes (in xl2003) Everything above the activecell and to the left of that activecell will be frozen. If you have data|filter|autofilter applied, show all the data before you freeze panes. Angee wrote: Hello All- I have seen this before and I have been trying to figure it out for months. How can I create a header row that is always visable as I scroll down the rest of m sheet? Like I can always see row 1 and it always meets up with the information in each column rather I am looking at row 2 or row 2005. Make sense? THANKS! I'd really appreciate any help, this has been driving me crazy and no one at work knows what I am talking about. -- Dave Peterson |
#4
|
|||
|
|||
Place your cursor immediately below the Header Row, click Window | Freeze Panes and you should be good to go.
Dean Hello All- I have seen this before and I have been trying to figure it out for months. How can I create a header row that is always visable as I scroll down the rest of m sheet? Like I can always see row 1 and it always meets up with the information in each column rather I am looking at row 2 or row 2005. Make sense? THANKS! I'd really appreciate any help, this has been driving me crazy and no one at work knows what I am talking about. Last edited by deangla : January 2nd 08 at 09:31 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Visable Data Only | New Users to Excel | |||
pasting into visable cells only | Excel Discussion (Misc queries) | |||
text visable but do not want printed | Excel Discussion (Misc queries) | |||
Visable Cells | Excel Discussion (Misc queries) | |||
Why isn't an 'ampersand' visable when inserted in a custom header. | Excel Discussion (Misc queries) |