Keep Top Row and Side Column always visible

[Guest]

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3

Thanks mate it was driving me nuts.

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3