Row/column "always on top"?

Posted by AceR on November 15, 2001 10:31 AM

I was wondering if it's possible to block a row so it doesn't get out of sight when you scroll down... For exapmle, if it stays on the top of the page, you can still know what every column is about...

I know you can block columns with MS Access, but is this also possible in Excel?

Hope someone knows the answer...

Greetz

AceR aka Ivan

Posted by Mark W. on November 15, 2001 10:41 AM

Use the Window | Freeze Panes menu command. For
instructions use the Excel Help Find facility to
locate the topic, "Keep row and column labels
visible as you scroll".

Posted by Katt on November 15, 2001 10:42 AM

Highlight the row under the row that you want to remain on top and go to Windows, Freeze Panes.
Easy as that.
KS

Posted by AceR on November 15, 2001 10:48 AM

Thanks a lot! I found it now.

Greetz

AceR, Ivan