Saving Zoom & Freeze Panes Settings on Multiple Worksheets Within a File

Posted by Suzanne on June 13, 2001 11:55 AM

Most of the Excel files that I work with contain multiple worksheets. As I work with any given file, I frequently zoom down to 80% and freeze the panes for row and column titles. This is a great feature. However, those settings are lost every time I close the file (even after saving). So, I must re-apply those settings every time I open the file.

I did a little digging through "Help" and found something called "Views".

Posted by Suzanne on June 13, 2001 11:59 AM

Oops! I accidentally hit "Enter" before I was finished...

The "Views" are no more convenient than re-applying the settings. Is there any way to save these settings with the file?

Posted by Ben O. on June 13, 2001 12:37 PM

Hmmm...I don't know why Excel wouldn't save your view settings. Mine does. Perhaps you have an earlier version. I use 2000.

Anyway, why not create macro that loads your view preferences? You could assign the macro to a button on the toolbar and apply it quickly every time you opened a new workbook:

Sub ViewSet()
ActiveWindow.FreezePanes = True
ActiveWindow.Zoom = 80
End Sub

You could also make one to do that to each sheet in your workbook:

Sub ViewSetAll()
For Each Sh In Sheets
On Error Resume Next
Sh.Activate
Range("B2").Select
ActiveWindow.FreezePanes = True
ActiveWindow.Zoom = 80
Next Sh
End Sub

I hope this helps.

-Ben

Posted by Suzanne on June 13, 2001 1:25 PM

Thanks a lot. Yeah, we have Excel 97. The macro/toolbar button is a good idea. I'll probably resort to that for now. But it sounds like I need to start pushing for Excel 2000.

Thanks again!

-Suzanne