Excel: How can I freeze some of a workbook
I am trying to freeze the unused cells so that I do not have to use the arrow
keys at the end of the data. |
Hiding the unused rows and columns then protecting the sheet is one method.
Setting the scrollarea using VBA is another method. Note: Setting ScrollArea is good for that session only and only the activesheet. Has to be reset next time workbook is opened. Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and specify which worksheet. Private Sub WorkBook_Open() Sheets("YourSheet").ScrollArea = "A1:M36" End Sub Gord Dibben Excel MVP On Tue, 15 Mar 2005 08:29:08 -0800, "Freeze unused cells" <Freeze unused wrote: I am trying to freeze the unused cells so that I do not have to use the arrow keys at the end of the data. |
All times are GMT +1. The time now is 03:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com