Continuous View
 

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


"Stacey" wrote in message
...
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.

You can either split the excel window or use the freeze panes facility. See
http://www.allaboutoffice.co.uk/exsplit.htm

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Stacey" wrote:

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.