Default zoom setting

This is probably a silly question but I cannot find an answer in Excel help or in this forum. When I open a new worksheet the zoom is set at 100%. I find 200% much easier to read and always reset to that as a first step. Not a big deal but is there a way to set the default to 200%?

Thank you

poppi

Hi Poppi,

There is no way to specifically do what you want but there are a couple of workarounds.

Workaround A. Create a template file that contains exactly one sheet with 200% zoom. Each time you want to create a new sheet, right click on the Sheet Tab > Insert > select your 200% file (which will insert a new sheet, which you will probably have to rename). I'm no expert on template files, but it seems like it has to go into your XLSTART folder or equivalent startup folder depending on your version of Excel.

Instructions:
(1) Find the XLSTART folder if you don't know it's location.
(a) Open Excel to a new file or any old file.
(b) Open VBE by pressing the Alt F11 keys.
(c) Open the Immediate Window by pressing the Ctrl G keys.
(d) Type '?Application.StartupPath' followed by the Enter Key (no apostrophes).
(e) Write down (or otherwise save) the XLSTART folder location that was displayed.

(2) Open up a new Excel file. Delete all Sheets except one. Set the zoom to 200% and possible rename the sheet to something other than 'Sheet1' if you want.

(3) Save the file as a template file with a name like '200Percent' (with the appropriate extension depending on your version of Excel). Some versions of Excel seem to save the template file in the correct XLSTART folder; other versions save the template file in a 'Custom Template' folder which does not help at all. Make sure to save the file in the XLSTART folder obtained in the first step.

(4) Close Excel

(5) To test your work: Open a new or old Excel file. Right Click the Sheet Tab > Insert. Your template file should be displayed as one of the choices. 'Double Click' the template file to insert a new 200% sheet into your Excel File.


Workaround B. Create a Macro in your Personal Macro Workbook that sets the zoom to 200%.
(1) Open a new or old Excel file.

(2) Prepare to record a Macro:
Excel 2003: http://www.computergaga.com/excel/20...d_a_macro.html
Other Excels: https://support.office.com/en-us/art...5-3ea70e64937b

(3) In the Record Macro Dialog Box:
(a) Select the Macro Name (MUST start with a letter) e.g. 'a200PerCent'.
(b) Optional: Select a ShortCut Key
(c) Make sure the Macro is stored in the 'Personal Macro Workbook'
(d) Select 'Create'

(4) Record the Macro. DO NOT USE THE SLIDER. View > Zoom > 200% > OK.

(5) Close the Excel File. Select 'Yes' to save the changes in the 'Personal Macro Workbook'.

(6) To run the Macro (Excel must be Open):
(a) Press 'Alt F8' and then 'Double Click' the Macro name.
(b) If Excel won't run the Macro due to a security problem see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.



The finished macro should look something like (Any line that begins with a 'single quote' is a comment line):

Please Login or Register  to view this content.

To access Visual Basic (VBA) and view/edit the macro see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.

The macro is probably in 'Module1' in Personal.XLS(B).
-----------------------------

I hope this helps.

Lewis