Continuous View

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

Guest

I would like to know how to view rows continuously as I scroll down an Excel
sheet. I have a spreadsheet that has column names at the top of the page.
The titles use up rows 1-3. How can I always see rows 1-3 when I scroll down
to the bottom of my data? I have seen it on other Excel spreedsheets but I
don't know how to do it.
 
Stacey

select cell A4 and then, from the menu, Window | Freeze panes

Regards

Trevor
 
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

Scrolling in Excel 2
Locking rows in Excel 97 3
How do I conceal the unused range from the scroll bar? 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Vertical Scroll issue with Excel 2013 1
Excel 2007 showing empty rows at bottom 1
How to fix the top-most 4 rows when scrolling? 1
Stationary Header 2

Back
Top