To keep a zoom level in an Excel workbook, open the worksheet, set the percentage from View > Zoom or the zoom control on the status bar, then save the workbook. Excel normally remembers zoom separately for each worksheet when you reopen the saved file; this does not change a single, global zoom setting for every workbook on your computer.
These steps are for Excel for Microsoft 365 on Windows. You can set one sheet or several sheets at once. If you mean that every new workbook should open at a chosen zoom, use the optional template method below.
What You’ll Need
- Excel for Microsoft 365 on Windows and the workbook you want to change.
- Permission to edit and save the workbook. If it is read-only or stored somewhere you cannot write to, save an editable copy first.
- A suitable file format, such as Excel Workbook (.xlsx), if the workbook does not need macros. Macro-enabled workbooks should remain in .xlsm format.
Step-by-Step
- Open the workbook and choose the worksheet. Click the sheet tab at the bottom of the Excel window. Zoom is a view setting for the active worksheet, so changing Sheet1 does not automatically change Sheet2. If you want different zoom levels on different sheets, set and save each one separately.
- Set the zoom percentage. For a precise value, select View > Zoom on the ribbon. In the Zoom dialog box, choose a listed percentage, or choose Custom, enter a value such as 90, and select OK. The allowed range is 10% to 400%. You can also click the percentage shown at the right end of the status bar, choose a value in the Zoom dialog, and confirm it.
- Use the status bar for quick adjustments. At the bottom-right of the Excel window, drag the zoom slider toward the minus sign to see more of the sheet or toward the plus sign to make cells appear larger. Click the displayed percentage if you want to enter or choose a specific value. The slider is convenient, but the dialog is better when you need an exact percentage.
- Check that the view is useful. Look at the headings and the data you work with most. A setting such as 80% or 90% may show more columns, while 110% or 125% may make text easier to read. Zoom changes how large the worksheet appears on screen; it does not resize the cells, alter values, or change the printed page scale.
- Save the workbook. Press Ctrl+S on Windows, or select File > Save. If Excel asks you to save a new workbook, choose a location and an appropriate workbook format. Close the workbook, then reopen it to confirm that the worksheet returns at the selected zoom. Saving is essential: changing the slider without saving may leave the file with its previous view.
- Repeat for other worksheets, if needed. Click another sheet tab, set its zoom, and save again. For example, you might use 100% on a data-entry sheet and 80% on a wide report. Save after making the changes so each sheet’s view is retained in the workbook.
- Apply one zoom level to several sheets at once, if that is your goal. Select the first sheet tab, then hold Ctrl and click each additional tab you want to change. For a consecutive group, click the first tab, hold Shift, and click the last. The selected tabs become grouped. Set the zoom while the sheets are grouped, then right-click a selected tab and choose Ungroup Sheets before continuing to work. Save the workbook. Grouping can apply other changes to every selected sheet too, so ungroup as soon as the zoom is set.
- For new workbooks, consider a startup template. Excel does not offer a general preference that forces a custom zoom in every existing and future file. To make new blank workbooks start from a chosen view, create a blank workbook, set the zoom on its sheet, and save it as an Excel Template named Book.xltx in Excel’s XLSTART folder. On a typical Windows installation, that folder is
%AppData%\Microsoft\Excel\XLSTART. You can enter that location in File Explorer’s address bar. Close and reopen Excel, then create a new workbook to check the template. This affects new workbooks created from the startup template, not files that already exist. If Book.xltx is already present, make a backup before replacing it.
Mac and web differences: In Excel for Mac, use the View tab’s zoom controls or the zoom slider, then save the workbook. Keyboard shortcuts differ: use Command+S to save. Excel for the web also has a worksheet zoom control, but the browser’s own zoom is separate. Browser zoom changes the size of the whole web page, not just the worksheet view saved in the workbook.
Common Mistakes
- Changing the zoom but not saving. The screen can look right until you close the file, then reopen at the old level. Save the workbook after changing the view, especially if AutoSave is off or the file is stored locally.
- Expecting one sheet’s setting to control the whole workbook. A workbook can have different zoom levels on different tabs. Set each sheet individually, or deliberately group the tabs before setting a shared level.
- Confusing worksheet zoom with print scaling. Zoom only changes the on-screen display. To make a worksheet fit on printed pages, look at the print scaling options under Page Layout or in the print settings instead.
- Using browser zoom in Excel for the web. Browser zoom affects the web interface and may make the ribbon and surrounding page larger or smaller. Use Excel’s worksheet zoom control when you only want to change the sheet display.
- Leaving sheets grouped. When multiple tabs are selected, editing cells, formatting, or deleting content can affect every selected sheet. Check the title bar or tab selection, and choose Ungroup Sheets before normal editing.
- Saving as a format that cannot retain workbook features. CSV files do not preserve a full Excel workbook, including multiple sheets and their usual workbook settings. Save a workbook view in .xlsx or the appropriate Excel workbook format.
Tips
Choose a zoom that suits the task rather than assuming 100% is always best. On a large monitor, 100% may be comfortable; on a small laptop screen, a lower value can reveal more columns. For checking detailed entries, temporarily increase the zoom, then return to the saved working level before you finish.
If you use several sheets for different purposes, set each up intentionally. A narrow input sheet may be easiest to read at 110%, while a wide dashboard may work better at 75%. The important point is to save after setting each sheet’s view and verify it by reopening the workbook.
For grouped sheets, use the method only when the sheets should share the same zoom. You can select tabs that are not next to each other with Ctrl-click on Windows, or Command-click on Mac. After changing the view, confirm that the selected tabs are no longer grouped. If you are unsure, set sheets one at a time; it takes longer but avoids accidentally applying edits to multiple sheets.
If you use the Book.xltx method, keep a separate copy of the template somewhere safe. Startup folders can vary by Office installation, and a template may be overwritten during troubleshooting or setup changes. Test by opening a genuinely new blank workbook rather than reopening an existing file, since an existing workbook keeps its own saved view.
Troubleshooting
- The workbook reopens at the old zoom: Open it, set the zoom again, press Ctrl+S, and check whether Excel shows a read-only or upload warning. Save a copy to a folder where you have permission, close it, and reopen that copy. Also confirm that you are reopening the same file rather than a duplicate.
- Only one worksheet changed: That is expected if only one tab was active. Set the other worksheets individually or group the desired tabs before changing zoom. Remember to ungroup them afterward.
- The zoom control is missing: The status bar may have been customized. Right-click the status bar and check its available options, or use View > Zoom from the ribbon. If the ribbon is collapsed, expand it or select the View tab.
- The new workbook does not use Book.xltx: Confirm that the filename is exactly Book.xltx and that it is in Excel’s XLSTART folder, not merely in Documents. Close all Excel windows and reopen Excel, then use File > New or Ctrl+N. If the organization manages Excel settings, template behavior may be restricted; remove or rename the template to return to the standard blank workbook.
- Excel for the web changes the whole page: Reset the browser zoom using its browser controls, then adjust the worksheet zoom inside Excel. These are separate controls and do not have the same effect.
- The displayed size still looks wrong on another computer: Zoom is only one part of how a sheet appears. Display scaling, window size, font rendering, and the active workbook view can make it look different. Check the zoom percentage in Excel itself and adjust it on that computer if needed.
Frequently Asked Questions
Does Excel save zoom for each worksheet?
Yes. In a saved workbook, each worksheet can retain its own zoom level. Set and save the view for every sheet you want to customize.
Can I make every Excel workbook open at 80%?
There is no standard global zoom preference for all existing files. You can set up a Book.xltx startup template for new blank workbooks, but each existing workbook keeps its own saved view.
Will changing zoom affect formulas, cell sizes, or printing?
No. Zoom changes only the on-screen magnification. It does not change formulas, stored values, row heights, column widths, or print scaling.
Why does a workbook open at a different zoom on another computer?
First check the worksheet’s zoom percentage and make sure the correct saved file was opened. Different screen sizes and display scaling can also change how large the sheet feels, even when the zoom percentage is the same.
Can I set a different zoom for each sheet?
Yes. Activate a sheet, set its zoom, and save. Repeat for each sheet where you want a different view.
Does Ctrl+S save the zoom setting?
Yes, in a normal editable Excel workbook. If the file is read-only, unsaved, or saved in a format that does not retain workbook features, save an editable .xlsx or .xlsm copy and reopen it to verify.
Related
- How to Add a Row in Excel: Shortcuts for Windows and Mac
- How to Add a Search Bar in Excel for Your Worksheet
- How to Add a New Line in an Excel Cell
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Shared Mailbox in Outlook: How to Add It on Windows and MacTo add a shared mailbox in Outlook, first make sure your Microsoft 365 or Exchange administrator has granted…
- How to Add a Footnote in a Word Document, Step by StepTo add a footnote in Microsoft Word, click where its numbered reference should appear, then select References >…
- Electrical Load List Excel Template: What to IncludeAn electrical load list Excel template is a worksheet for recording each electrical load, its supply details, rated…
- Scatter Plot in Excel: Create, Format, and Read ItTo create a scatter plot in Excel for Microsoft 365 on Windows, put your X values in one…
- Excel Shortcut to Make All Cells Fit Text AutomaticallyIn Excel for Microsoft 365 on Windows, select the cells or columns, then press Alt, H, O, I…
- Excel Keyboard Shortcuts Cheat Sheet for Windows UsersFor Excel for Microsoft 365 on Windows, the most useful shortcuts include Ctrl+C to copy, Ctrl+V to paste,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.