Excel Spreadsheet Zoom Lock: How to Freeze Zoom Level

How-to basics · Updated November 22, 2026

You cannot permanently lock the zoom level in Excel, but you can set a default zoom for all new workbooks and use View tab options to control the display. The zoom setting is a view property, not a saved workbook property, so it resets when you open a file on another computer or after certain actions.

Why Excel Doesn’t Have a Zoom Lock

Excel treats zoom as a display preference tied to the Excel application session, not to the workbook file itself. When you save a workbook, the zoom percentage is not stored in the file. If you open the same file on a different machine, Excel uses that machine’s default zoom (usually 100%). This is by design—zoom is meant to be a temporary viewing aid, like scrolling, not a permanent part of the document.

However, you can set a default zoom that applies to every new workbook you open in Excel on your computer. This is the closest thing to a “lock” for your own use.

How to Set a Default Zoom for All New Workbooks

To make Excel always open new workbooks at a specific zoom level (e.g., 120%):

  1. Open Excel and go to File > Options.
  2. In the General tab, look for the When creating new workbooks section.
  3. Change the Default zoom for new workbooks dropdown to your desired percentage (e.g., 120%).
  4. Click OK.

This affects all new workbooks you create on that computer. Existing workbooks are unaffected, and the setting is stored in your Excel user profile, not in the workbook file.

Using the View Tab for Quick Zoom Control

For a single workbook, you can use the View tab on the ribbon:

  • Zoom button opens a dialog to enter a custom percentage (10% to 400%).
  • 100% button resets to 100%.
  • Zoom to Selection fits the selected cells to the window.

These are temporary and apply only to the current window. If you switch to another sheet in the same workbook, the zoom stays the same—it’s per window, not per sheet.

How to Lock Zoom for a Specific Workbook (Workaround)

Since Excel doesn’t save zoom in the file, you can use a small VBA macro that runs when the workbook opens and sets the zoom to your preferred level. This is the only way to force a specific zoom for a file on any computer (assuming macros are enabled).

To add this macro:

  1. Press Alt+F11 to open the VBA editor.
  2. In the Project Explorer, double-click ThisWorkbook.
  3. Paste the following code:
Private Sub Workbook_Open()
    ' Set zoom to 120% when the workbook opens
    ActiveWindow.Zoom = 120
End Sub
  1. Close the editor and save the workbook as a macro-enabled file (.xlsm).

Important: Save a copy of your workbook before running any macro, because macros cannot be undone with Ctrl+Z. Also, macros must be enabled for this to work; if they are disabled, the zoom won’t change.

Why Zoom Resets When You Switch Sheets or Scroll

A common complaint is that zoom “resets” when you click on a different sheet. This usually happens because each sheet has its own zoom setting in the same window? Actually, no—the zoom is per window, not per sheet. If you change zoom on Sheet1, then click on Sheet2, the zoom stays the same. However, if you use Zoom to Selection, it changes the zoom for that sheet only, and when you move to another sheet, the zoom may revert to the previous level. Also, if you close and reopen the workbook, the zoom resets to the default because it’s not saved.

Another cause: if you have multiple windows of the same workbook (View > New Window), each window has its own zoom. Closing a window and reopening it will reset the zoom.

Common Problems and Misconceptions

Misconception: “I can lock zoom so other users can’t change it.” This is not possible. Zoom is a client-side view setting; it cannot be protected or locked via sheet protection or workbook protection. Even if you set a default zoom via VBA, users can still change it manually.

Problem: “My zoom keeps changing when I use Ctrl+scroll.” This is the mouse wheel zoom feature. To disable it, go to File > Options > Advanced, and under Editing options, uncheck Zoom on roll with IntelliMouse. This prevents accidental zoom changes but does not lock the zoom level.

Zoom Lock in Excel for the Web and Mac

Excel for the web (browser) has a zoom control in the bottom-right corner, but it does not have a default zoom setting. The zoom resets to 100% each time you open the workbook. There is no VBA in the web version, so you cannot automate it.

Excel for Mac (Microsoft 365) has a similar default zoom option under Excel > Preferences > General, but the VBA approach works only in the Windows desktop version. On Mac, you can use the View menu to set zoom, but it’s not saved.

Frequently Asked Questions

Q: Can I lock the zoom level in Excel so it stays at 100%?
A: Not permanently. You can set the default zoom to 100% in Options, but if a user changes it, it won’t revert until you close and reopen the workbook. The VBA method can force it on open, but users can still change it afterward.

Q: How do I make Excel open at 150% zoom every time?
A: Go to File > Options > General and set the default zoom to 150%. This applies to all new workbooks on your computer. For a specific existing workbook, use the VBA workaround above.

Q: Why does my zoom reset when I save and reopen?
A: Because zoom is not saved in the file. It’s a display setting that resets to the application default. If you want it to persist, you must use VBA to set it on open.

Q: Can I lock the zoom for other users who open my spreadsheet?
A: No. There is no built-in feature to prevent users from changing zoom. Even with VBA, a user can simply change the zoom manually after the macro runs.

Q: How do I turn off the mouse wheel zoom in Excel?
A: Go to File > Options > Advanced, and under Editing options, uncheck “Zoom on roll with IntelliMouse.” This stops the Ctrl+scroll zoom behavior.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.