scroll area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 **
 
*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...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Title row to stay in place when scrolling down 2
Another Autocomplete question! 1
How to fix the top-most 4 rows when scrolling? 1
How do I do this? 2
Row Scrolling with a Page 1
Missing Column Headers / Can't scroll to top 2
Need Help with Freezing/Splitting 2 Frames in Excel 2003 3
how do i set half an excell sheet to now scroll with the rest. 3

Back
Top