| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in Excel how do you set a workbook to only open on the first work. | Excel Discussion (Misc queries) | |||
| Fixing broken hyperlinks in Excel workbook | Excel Discussion (Misc queries) | |||
| Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
| link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
| Create invoices from excel workbook | Excel Worksheet Functions | |||
Linear Mode
