Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Every time I open a new workbook or worksheet in Microsoft Excel, I find myself adjusting the view to my preferred view of 80%. Is there a way to make 80% the default?

I have tried two things, which haven't worked:

  1. Saving book.xltx and sheet.xltx in XLSTART folder
  2. In Excel Options, changing the default criteria for when a new workbook opens (no option for % view here)

Perhaps I am doing step #1 wrong or there is more to do there OR I need to use VBA and I'm not sure how to do that.

Any help would be greatly appreciated, thank you stackoverflow community!

share|improve this question
add comment

1 Answer 1

You can create a macro in your Personal.xlsb. If you don't know whether that is active, follow these steps:

Start the Macro Recorder and in the "Record Macro" dialog select "Personal Macro Workbook" in the drop-down for "Store macro in". Set the name as ZoomLevel80. Hit OK and set the Zoom level to 80%. Stop the macro recorder.

Now hit Alt-F11 to open the Visual Basic Editor. On the left, find the VBA Project (Personal.xlsb). In the "Modules" section you will find a module with the macro you just recorded, but we can leave that alone.

Select the "This Workbook" module and in the code window put this code:

Private Sub Workbook_Open()
    ActiveWindow.Zoom = 80
End Sub

enter image description here

Click the Save icon. Now close Excel. The personal macro workbook is loaded every time Excel starts. The macro code above will run every time this macro workbook is opened.

The Zoom level is stored with each workbook, though, so when you open another workbook that was not set to 80% zoom, you can use the recorded macro. Assign a keyboard shortcut to the macro: Click the "Macros" icon on the Developer ribbon. Select the macro ZoomLevel80, click the Options button and enter a keyboard shortcut, for example Ctrl-8.

The screenshots have been taken with 2010, but the same principle applies in 2013.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.