Keep Top Row and Side Column always visible
 

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

Keep Top Row and Side Column always visible
 

Place the cursor in cell B2 and do Windows Freeze Panes

Vaya con Dios,
Chuck, CABGx3



"Anti-Spam" wrote:

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

Keep Top Row and Side Column always visible
 

On Tue, 15 Jan 2008 12:29:02 -0800, CLR
wrote:

Place the cursor in cell B2 and do Windows Freeze Panes

Vaya con Dios,
Chuck, CABGx3



"Anti-Spam" wrote:

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


Thanks mate it was driving me nuts.

Keep Top Row and Side Column always visible
 

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

Vaya con Dios,
Chuck, CABGx3



"Anti-Spam" wrote:

On Tue, 15 Jan 2008 12:29:02 -0800, CLR
wrote:

Place the cursor in cell B2 and do Windows Freeze Panes

Vaya con Dios,
Chuck, CABGx3



"Anti-Spam" wrote:

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


Thanks mate it was driving me nuts.