Continuous View

[Stacey]

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.

[Trevor Shuttleworth]

Stacey

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

Regards

Trevor


"Stacey" <Stacey@discussions.microsoft.com> wrote in message
news:65401896-A724-41AC-A316-FB19E2B3E02B@microsoft.com...
>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.

[Andrea Jones]

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.