Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Preventing rows from scrolling in Excel???

Posted by Max Powers on April 27, 2001 1:27 AM
(If you reply by e-mail, remove SPAM from the address)

How can you prevent rows from scrolling in a sheet?

I would like to have row 1 & 2 visible on the screen even if I use the scrollbar to scroll down to row 100.
(Like a frame in HTML, row 1 & 2 in the top frame and the rest in the main frame, see below)
____________________________________
ROW
1 TITLE
2 TOTAL SUM
------------------------------------
44 SUM 44
45 SUM 45
46 SUM 46
____________________________________


TIA!!!


Re: Preventing rows from scrolling in Excel???

Posted by Ian Bartlett on April 27, 2001 3:58 AM
Click on a cell just below the rows you want to keep on the screen, and just to the right of any columns you want to keep (ie. if you want to keep rows 1 & 2, and columns A, B & C, click cell D3).

Then click Windows, Freeze Panes. Remove them with Windows, Unfreeze panes.

HTH,

Ian


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.