To change the default zoom for a worksheet in Excel for Microsoft 365 on Windows, open the sheet, choose View > Zoom, select a percentage, and save the workbook. Excel remembers the zoom with the worksheet, so set it separately on any other sheets you want to open at a different size. If you mean the zoom for every new workbook, use a startup template; Excel does not have one universal zoom switch for all files.
Changing zoom affects how large cells look on screen, not their contents, row heights, column widths, or printed scale. Before starting, decide whether you are changing one existing workbook, several worksheets, or the starting view for new workbooks.
What You’ll Need
- Excel for Microsoft 365 on Windows, and permission to edit the workbook.
- A saved workbook if you want a zoom change to be available the next time you open it.
- For a new-workbook default, access to the Excel startup folder and the ability to save an Excel template. This is optional.
Step-by-Step
- Open the workbook and choose the worksheet. Open the file, then click the sheet tab whose zoom you want to change. Zoom is a view setting that can differ from sheet to sheet, so do not assume changing one tab will set every tab. If the workbook has many sheets, identify the ones you use most often before changing anything.
- Make sure you are in Normal view. On the ribbon, select View > Normal if the workbook is currently in Page Layout or Page Break Preview and you want the usual worksheet grid. Zoom can be adjusted in different views, but the page-oriented views may make the screen look different because they show margins or page boundaries. Normal view is generally the clearest place to choose an everyday working zoom.
- Open the Zoom dialog. Select View > Zoom in the ribbon. In the dialog, choose one of the listed percentages, such as 75%, 100%, or 200%, or choose Custom and enter a number from 10% through 400%. Select OK to apply it. A lower percentage shows more cells at once; a higher percentage makes text and cells larger but shows less of the worksheet.
- Choose a useful percentage rather than copying another screen. For a typical laptop display, try 100% first, then adjust in small steps. The same percentage can appear larger or smaller on different monitors because display size and resolution vary. Check that column headings, row labels, and frequently used values are readable without making the worksheet unnecessarily cramped.
- Use the status-bar control for a quick adjustment. At the bottom-right of the Excel window, use the minus and plus buttons or drag the zoom slider. The current percentage is displayed beside the slider; click the percentage to open the Zoom dialog if that control is available in your window. This is convenient for small adjustments, while the dialog is useful when you need an exact value such as 85%.
- Set the zoom on other worksheets individually. Click another sheet tab and repeat the adjustment. For example, a wide summary sheet might be easier to read at 80%, while a short data-entry sheet may work better at 110%. Check the workbook’s important tabs one at a time. If you change the view on a tab by mistake, return to that tab and set its intended percentage.
- Save the workbook. Press Ctrl+S on Windows, or choose File > Save. Excel normally retains the worksheet view with the workbook, but a change that has not been saved may be lost if you close the file or discard changes. If AutoSave is on for a file stored in OneDrive or SharePoint, still allow the save to finish before closing.
- Reopen or revisit the workbook to check the result. Confirm that the intended sheet opens at a comfortable size and that other sheets have the settings you chose. If the workbook opens to a different tab, click the tab you care about and check its zoom there. The active sheet and its saved view determine what you see when working in the file.
- Optional: set the starting zoom for new workbooks with a template. In Excel desktop, create a blank workbook, set the zoom on its first sheet, then use File > Save As > Browse. Choose Excel Template (*.xltx) as the file type, name the template
Book.xltx, and save it in Excel’sXLSTARTfolder. On Windows, you can enter%appdata%\Microsoft\Excel\XLSTARTin File Explorer’s address bar to locate the usual folder. Close and restart Excel, then create a new workbook to check the template. Back up or rename an existingBook.xltxbefore replacing it. A template namedSheet.xltxin the same startup folder can provide a default for newly inserted worksheets.
On Mac, use the View menu or the zoom control at the bottom of the Excel window; the Windows View > Zoom ribbon path and startup-folder location may differ. Excel for the web has its own zoom control, but browser zoom changes the entire page and browser interface. For a reusable default on new files, configure and test a template in desktop Excel rather than relying on browser zoom.
Common Mistakes
- Expecting a global setting. Changing a sheet’s zoom does not create an application-wide preference that overrides every workbook. Existing workbooks can each have their own saved sheet views. Use a startup template if your goal is to influence newly created workbooks.
- Changing only one tab. A workbook may open with one sheet at 100% and another at 80%. Set and check the zoom on each worksheet where the view matters, then save the file.
- Confusing zoom with print scaling. A 70% screen view does not make the printed worksheet 70% of its former size. To change printed output, use the page layout and print settings instead. Changing screen zoom alone should not be used to fit a report onto a printed page.
- Using browser zoom to fix worksheet zoom. Browser zoom enlarges or shrinks Excel for the web’s whole interface, not just the cells. It can make menus and controls awkward to use and may not match how the workbook looks in desktop Excel.
- Forgetting to save or replacing a template without a backup. Unsaved view changes may not persist. A new
Book.xltxcan also replace an existing startup template, so copy the old file somewhere safe first.
Tips
- Use Zoom to Selection for a focused view. Select a range, then choose View > Zoom to Selection. Excel adjusts the view to show that range. This can help when presenting a compact table, but it is not a fixed percentage and may leave the rest of the sheet outside the visible area. Set a normal percentage again when you are done.
- Choose zoom based on the task. A data-entry sheet may need larger text, while a dashboard with several columns may need a smaller setting. Consider the people who will open the workbook, not just the size that fits your own monitor.
- Keep a standard view for shared files. When colleagues use different screens, a moderate zoom such as 90% or 100% is often a practical starting point. Ask a colleague to check readability if the workbook is shared widely; one percentage cannot guarantee the same physical text size on every device.
- Separate screen readability from workbook layout. If text is hard to read, first try zooming in. If you still need a very large zoom just to read a few columns, consider widening important columns, wrapping headings, or freezing panes. Those layout changes affect the sheet itself, so make them only when they improve the workbook for its intended users.
- Check each view mode. A percentage that looks comfortable in Normal view may feel different in Page Layout view, where margins and page boundaries take up screen space. Set the view you normally work in, and use print preview separately to inspect printed pages.
Troubleshooting
The zoom changes back after closing Excel. Reopen the workbook, set the zoom on the relevant sheet, press Ctrl+S, and wait for saving to finish. Close and reopen the same file to check. If you opened a read-only copy, a protected file, or a file from a location where you cannot save, the view change may not be retained. Save an editable copy in a location where you have permission.
Only one worksheet has the new zoom. That is normal when you changed just the active tab. Click each other sheet and set its zoom separately. Also confirm that you are checking the same workbook file you saved; duplicate files with similar names can make it seem as if the setting disappeared.
New workbooks still open at the old zoom. Check that the template is named exactly Book.xltx, is saved in the correct Excel XLSTART folder, and was created with the intended zoom. Restart Excel after adding or changing the template, then create a genuinely new workbook to test it. A workbook opened from an existing file is not a new workbook and will keep its own saved view. If the template is ignored, check whether your organization manages Excel startup settings or has another startup template.
The worksheet looks tiny even though the zoom percentage is correct. Confirm that you are adjusting Excel’s worksheet zoom rather than Windows display scaling or browser zoom. Try a slightly larger percentage and check the monitor’s display resolution and scaling settings if menus and other apps also look unusually small. A zoom value does not correspond to the same physical text size on every screen.
The slider or Zoom command is unavailable. Maximize the Excel window and check the View tab. In a protected or shared work environment, some commands may be restricted by workbook settings or administrator policy. If the file is open in a browser, try opening it in the desktop app for the full ribbon and template options.
Frequently Asked Questions
Can I set one default zoom for every Excel file?
Not with a single general preference in Excel for Microsoft 365 on Windows. Existing workbooks retain their own views. A Book.xltx startup template can set the starting view for new workbooks, but it does not rewrite the zoom in files you already have.
Does changing zoom change the printed worksheet?
No. Zoom changes the on-screen view. To control the printed size or fit content to pages, use print settings such as scaling and page setup, then inspect Print Preview.
Can different sheets in one workbook use different zoom levels?
Yes. Set the view on each sheet individually and save the workbook. For example, you can keep a wide chart sheet at a smaller zoom while leaving a text-heavy sheet larger.
How do I return to the usual 100% view?
Select the worksheet, choose View > Zoom, select 100%, and choose OK. You can also use the status-bar zoom control to return to 100%.
Does this work in Excel for the web?
Excel for the web offers a worksheet zoom control, but its interface and saving behavior are not identical to desktop Excel. Use the workbook zoom control rather than browser zoom, and reopen the file to verify the view. Startup templates require desktop Excel.
Will another person see my zoom setting?
If the view is saved with the workbook, another person opening that file may see the saved worksheet zoom. Their screen size and display scaling can make it look different. If the workbook is shared, save it and ask the recipient to check the view on their device.
Related
- How to Add Serial Numbers in Excel Automatically
- How to Add Page Numbers in Excel
- How to Add a Row in Excel: Shortcuts for Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Set an Out of Office Invite in Outlook CalendarTo set an out of office invite in Outlook, create a calendar event, choose Show as > Out…
- Center Text in Excel: Keyboard Shortcut and How to Use ItTo center text horizontally in Excel for Microsoft 365 on Windows, select the cell or cells and press…
- Google Sheets COUNTIF: Find Cells with Partial TextYes. In Google Sheets, use COUNTIF with asterisks around the text you want to find: =COUNTIF(A2:A8,"*tea*") counts cells…
- Excel Vertical Text: How to Rotate Text in CellsTo make text vertical in Excel for Microsoft 365 on Windows, select the cell or range, then choose…
- Excel Time Format: Show Hours and Minutes Only CorrectlyTo show hours and minutes in Excel, select the cells, press Ctrl+1, choose Custom, and enter h:mm (or…
- Conditional Formatting for Overdue Dates in Excel: GuideIn Excel for Microsoft 365 on Windows, select the date cells, choose Home > Conditional Formatting > New…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.