How to keep first row in spreadsheet

Thread view:

Thread rating:

Misstory888 - 07 Jan 2005 18:24 GMT

How can I keep my first row on my spreadsheet? For instance, row 1 will
always stay on even when I'm scrolling down it.

RWN - 07 Jan 2005 20:08 GMT

Select A2 and "Window->Freeze Panes"

Signature

Regards;
Rob
------------------------------------------------------------------------

> How can I keep my first row on my spreadsheet? For instance, row 1 will
> always stay on even when I'm scrolling down it.

Gord Dibben - 07 Jan 2005 22:35 GMT

Select A2 and click on Window>Freeze Panes" to freeze Row 1

To freeze column A also select B2.

Gord Dibben Excel MVP

>How can I keep my first row on my spreadsheet? For instance, row 1 will
>always stay on even when I'm scrolling down it.

Jack in the UK - 13 Jan 2005 23:20 GMT

> *How can I keep my first row on my spreadsheet? For instance, row 1
> will
> always stay on even when I'm scrolling down it. *

If you prefer you can always split the screen

Jack

--
Jack in the UK