Keep Top Row and Side Column always visible

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anti-Spam - 15 Jan 2008 19:53 GMT

I have a simple spreadsheet which has many rows, most of which are
outside the visible area on my screen. The top row (number 1) has my
column headings, trouble is as soon as you scroll down the headers
disappear off the top of the screen. Is there any way to lock them, so
they do not scroll with the rest of the sheet. Thanking you in
anticipation.

Mark in Spain.

XP Pro
Excel version 2002
XP Office Pro

Reply to this Message

CLR - 15 Jan 2008 20:29 GMT

Place the cursor in cell B2 and do Windows > Freeze Panes

Vaya con Dios,
Chuck, CABGx3

> I have a simple spreadsheet which has many rows, most of which are
> outside the visible area on my screen. The top row (number 1) has my
[quoted text clipped - 8 lines]
> Excel version 2002
> XP Office Pro

Reply to this Message

Anti-Spam - 15 Jan 2008 20:38 GMT

>Place the cursor in cell B2 and do Windows > Freeze Panes
>
[quoted text clipped - 13 lines]
>> Excel version 2002
>> XP Office Pro

Thanks mate it was driving me nuts.

Reply to this Message

CLR - 16 Jan 2008 15:34 GMT

Happy to help............thanks for the feedback

Vaya con Dios,
Chuck, CABGx3

> >Place the cursor in cell B2 and do Windows > Freeze Panes
> >
[quoted text clipped - 15 lines]
>
> Thanks mate it was driving me nuts.

Reply to this Message