How to Set the Default Excel Zoom Level to 80 Percent
Question details
The user wants to configure Excel so that every new workbook or worksheet automatically opens with the zoom level set to 80 percent.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating or opening new Excel workbooks for daily tasks.
- Observed behavior
- Excel opens new workbooks at the standard 100 percent zoom level by default, as there is no built-in application-wide setting to change the default zoom percentage globally.
Because Excel stores zoom settings individually per worksheet rather than as a global application setting, you will need to create a custom workbook template or utilize a simple VBA macro to achieve this.
Create a Custom Default Workbook Template
Save a blank workbook with an 80% zoom level as a template in the XLSTART folder so all future workbooks start with this exact view.
This is the most reliable method for ensuring that any completely new workbook you create opens at 80% zoom without relying on macros.
Launch Excel and open a standard blank workbook. Select all default sheets if there are multiple.
Go to the 'View' tab on the ribbon and click 'Zoom', or use the slider in the bottom right corner of the window to set the zoom exactly to 80%.
Click 'File' > 'Save As'. In the file type dropdown menu, select 'Excel Template (*.xltx)'.
Name the file 'Book.xltx' and save it to your XLSTART folder. This is typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART. The next time you open a new workbook, it will use this template.
Use a VBA Macro to Set Zoom on Open
Apply an 80% zoom level automatically whenever a workbook or worksheet opens by using a short VBA script.
Try WPS Office for a Seamless Spreadsheet Experience
If you are looking for a more flexible and lightweight spreadsheet tool, WPS Office provides a highly compatible, free alternative to Microsoft Office. It offers an intuitive interface and excellent performance without heavy resource usage.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer. Once completed, open WPS Spreadsheet to start a new document.
- 3. Open Excel Files Seamlessly: Simply drag and drop your existing .xlsx files into WPS Spreadsheet to continue working exactly where you left off, with your preferred zoom settings.
Frequently Asked Questions
Why doesn't Excel have a built-in global zoom setting?
Microsoft designed Excel to save zoom levels at the worksheet level rather than globally. This is because different datasets, charts, and table sizes often require completely different viewing scales for optimal readability.
Where is the XLSTART folder located?
On Windows, the XLSTART folder is typically located in C:\Users\[Username]\AppData\Roaming\Microsoft\Excel\XLSTART. Any valid template named Book.xltx placed in this directory is automatically used as the foundation for all new standard workbooks.
Will changing the zoom level affect how my spreadsheet prints?
No, the zoom level at the bottom of your screen only affects how the document appears visually on your monitor. It does not alter the actual print dimensions, margins, or page layout scaling settings.
Why isn't my VBA macro running when I open a workbook?
Macro execution is often restricted by default Office security settings. You need to save the file in a macro-enabled format (.xlsm or .xlsb) and ensure that macros are permitted to run within your Excel Trust Center settings.
