Home |
Search |
Today's Posts |
#1
|
|||
|
|||
header row
Hi,
simple question - I hope. I have a worksheet with the first row that has titles for each column. I want to be able to scroll down the worksheet but still keep the header (first row) at the top of the screen so I can see the titles of each of the columns. I thought this was easy but I cant do it. I thought freeze pane was it but that picks its own boundaries. Any help will be most appreciated. Thanks |
#2
|
|||
|
|||
Click in A2, Window | Freeze Panes.
-- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200507/1 |
#3
|
|||
|
|||
freeze panes is what you want, click in A2 and then freeze pane, or if you
also want to keep some of the columns on the left click somwhere like C2 -- 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 "nospam" wrote in message ... Hi, simple question - I hope. I have a worksheet with the first row that has titles for each column. I want to be able to scroll down the worksheet but still keep the header (first row) at the top of the screen so I can see the titles of each of the columns. I thought this was easy but I cant do it. I thought freeze pane was it but that picks its own boundaries. Any help will be most appreciated. Thanks |
#4
|
|||
|
|||
Hi. Here's the "rules" for Freeze Panes:
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "nospam" wrote in message ... Hi, simple question - I hope. I have a worksheet with the first row that has titles for each column. I want to be able to scroll down the worksheet but still keep the header (first row) at the top of the screen so I can see the titles of each of the columns. I thought this was easy but I cant do it. I thought freeze pane was it but that picks its own boundaries. Any help will be most appreciated. Thanks |
#5
|
|||
|
|||
See if this old post helps explain things:
http://tinyurl.com/2qdzt -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "nospam" wrote in message ... Hi, simple question - I hope. I have a worksheet with the first row that has titles for each column. I want to be able to scroll down the worksheet but still keep the header (first row) at the top of the screen so I can see the titles of each of the columns. I thought this was easy but I cant do it. I thought freeze pane was it but that picks its own boundaries. Any help will be most appreciated. Thanks |
#6
|
|||
|
|||
VoG via OfficeKB.com writes
Click in A2, Window | Freeze Panes. Brilliant - Thanks |
#7
|
|||
|
|||
Anne Troy writes
Hi. Here's the "rules" for Freeze Panes: http://www.officearticles.com/excel/...soft_excel.htm Thanks for that. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "nospam" wrote in message ... Hi, simple question - I hope. I have a worksheet with the first row that has titles for each column. I want to be able to scroll down the worksheet but still keep the header (first row) at the top of the screen so I can see the titles of each of the columns. I thought this was easy but I cant do it. I thought freeze pane was it but that picks its own boundaries. Any help will be most appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format in Header | Excel Discussion (Misc queries) | |||
Graphic in Header scaling with pages contents | Excel Discussion (Misc queries) | |||
header or footer | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) |