Zoom default setting

[eunharanft]

Hi,

How can I set up the zoom % default so that I don't have to adjust it every time? I couldn't find it under option. Thanks.

[Damon Ostrander]

Hi eunharanft,

The reason that there is no default setting under Tools > Options is that each worksheet has its own zoom factor--it is not a workbook- or application-level property. Each worksheet's zoom factor is [supposed to be] saved whenever the workbook is saved, so if you set the zoom factor, then save (you may have to close Excel), the sheet should display with the same zoom factor the next time the workbook is opened. The one exception to this is that if the sheet is a chart sheet, if the View > Sized with Window menu item is checked autosizing will override the zoom factor.

If this does not solve your problem, you could always set the zoom factor for a particular sheet in the sheet's Activate event or in the ThisWorkbook Open event so that the sheet is always initialized to a particular zoom.

Damon