scroll area

P

Pringles.

i recently downloaded a the "checkbook register" template from the excel
templates page, and was intriuged as to how they make they labels and title
at the top stay there while the rest of the sheet scrolls as needed. is this
a VBA command or is it a simple header?
 
P

Paul B

Pringles, have a look at windows freeze panes, select A2 and then freeze
panes and row one will stay at the top when you scroll

--
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 2000 & 2003
** remove news from my email address to reply by email **
 
P

Pringles.

*gasp* it worked wonderfully! thanks mcuh

Paul B said:
Pringles, have a look at windows freeze panes, select A2 and then freeze
panes and row one will stay at the top when you scroll

--
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 2000 & 2003
** remove news from my email address to reply by email **
Click to expand...
 
P

Pringles.

wait. it didn't work. now i can't see what's at the top without unfreezing
the panes.
check out the template i mentioned to see what i mean.
 
Top