???is there a way to keep one row in view while scrolling down???

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

Guest

Hi all,
I'm trying to make a spread sheet that will hold many rows of data, so if
we're on, for example, the 1000th row the first row that says:

Month Date Name Etc

will still be visible.... like it doesn't move as your scroll. Is there any
way excel can do this?? Please give specific instructions.
Thanks in advance
 
Click on Cell A2, then do Windows > FreezePanes...........row ! will stay
frozen as you scroll..........reverse the procedure to unfreeze it.........



Vaya con Dios,
Chuck, CABGx3
 
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

Excel Help to copy information from one row at a time to another sheet 1
Keeping column name in view when scrolling 2
How do I keep the top row of a spread sheet visable? 1
Is there a way to restrict the view of a worksheet 1
How to view tiled Excel worksheets by locking rows for scrolling . 1
Is there any way to auto-insert a row? 4
Find Date in range and scroll down to next row 2
Group information from several worksheets into one worksheet 1

Back
Top