To change the zoom in Excel for Microsoft 365 on Windows, use the zoom slider at the bottom-right of the Excel window, or select View > Zoom and enter a percentage. Zoom changes how large the worksheet appears on screen; it does not change cell contents, row heights, column widths, or printed page size.
What You’ll Need
- An Excel workbook open in the desktop version of Excel. The same basic controls are available in Excel for the web, though their location or appearance can vary slightly.
- A worksheet you want to view at a different size. If you want to zoom in on a particular block of cells, select that range first.
Step-by-Step
- Open the worksheet you want to adjust. Zoom is a viewing setting for the active worksheet, so first click its sheet tab at the bottom of the workbook. If the workbook has several sheets, make sure you are changing the one you intend to use. You can set a different zoom level on another sheet afterward.
- Use the status bar for a quick adjustment. Look at the bottom-right corner of the Excel window. The status bar shows a percentage, such as 100%, next to a minus button, a slider, and a plus button. Click the plus button to increase zoom or the minus button to decrease it. Each click moves the slider by a step; the displayed percentage updates so you can see the current level.
- Drag the zoom slider. For a larger change, drag the slider marker toward the plus sign to zoom in or toward the minus sign to zoom out. Watch the percentage as you move it, then release the mouse when the worksheet is readable and enough columns or rows remain visible. The slider normally allows settings from 10% to 400%.
- Enter an exact percentage from the Zoom dialog. Select View > Zoom on the ribbon. In the dialog, choose one of the listed percentages or select Custom, type a value such as 125, and click OK. Enter the number as a percentage value, not a decimal: type 125 for 125% rather than 1.25. Excel accepts values within its supported zoom range.
- Return to the standard view when needed. Select View > Zoom > 100%, or click the percentage on the status bar and choose 100% through the Zoom dialog. This resets the display scale to its usual reference size. It does not undo other view choices, such as Freeze Panes or the selected workbook view.
- Zoom to a particular selection. Select the cells you want to inspect, then choose View > Zoom to Selection. Excel adjusts the magnification so the selected range fills as much of the window as practical. This is helpful for a chart, a compact report, or a wide table. It may make surrounding cells difficult to see, so use 100% or another fixed percentage to return to a broader view.
- Check the result and save if appropriate. Confirm that the text and cells are comfortable to read and that the amount of the sheet visible suits your task. Excel usually retains worksheet view settings with the workbook, but the view can differ by sheet. Save the workbook if you want the adjusted view to be available the next time you open it.
You can also adjust zoom with the keyboard and mouse on Windows: hold Ctrl while scrolling the mouse wheel up to zoom in or down to zoom out. This is convenient for small changes, but the result can jump in increments and may be less precise than typing an exact percentage. On a Mac, use the zoom control in the status bar or the Zoom commands on the View tab; the Windows Ctrl-plus-wheel gesture should not be assumed to work the same way with Mac hardware and settings.
Common Mistakes
- Changing zoom when you meant to change print size. Worksheet zoom only affects on-screen display. If the printed result needs to fit a page, use the page layout and print scaling controls instead. For example, choose Page Layout and inspect the Scale to Fit options, or review the print preview. Changing screen zoom will not make the printed text larger or smaller.
- Typing a decimal instead of a percentage. The Custom field expects a percentage number. Typing 125 gives 125%; typing 1.25 does not mean 125%. If the dialog rejects a value, use a whole-number percentage in the supported range.
- Expecting every worksheet tab to change together. The active sheet is the one being adjusted. A different sheet may retain another zoom level, so check each tab if you need a consistent view across the workbook.
- Using Zoom to Selection and then assuming the workbook is broken. A large selected range or a very small selection can produce a surprising magnification. It changes the view to frame the selection; it does not delete, hide, or resize the cells. Set a regular percentage to get back to a predictable view.
- Confusing zoom with display scaling. Windows display scaling, Excel’s ribbon size, and worksheet zoom are separate controls. Zooming the sheet changes the apparent size of cells and worksheet contents, while operating-system scaling can affect the size of the entire Excel interface.
Tips
- Choose zoom based on the task. A level below 100% can show more columns for comparing figures across a wide table. A level above 100% can make small labels or detailed cells easier to read. There is no single best setting; choose one that leaves the relevant headings visible as well as the data.
- Use Zoom to Selection for focused review. Select the full area you need, including row and column labels if they matter, before invoking the command. Excel can frame only the selection, so omitting important headers may make the enlarged view harder to interpret.
- Keep the status bar visible. If you do not see the percentage or slider, maximize the Excel window or widen it. A narrow window can hide some status-bar controls. The View tab provides another route to the Zoom dialog even when the slider is inconvenient.
- Remember that zoom does not change the data. Formulas, values, formatting, and chart data remain the same. This makes zoom safe to adjust while reviewing a workbook, although it is still sensible to save important work as you normally would.
- Consider screen size and resolution. A percentage that looks comfortable on one monitor may be too large or too small on another. If you use a laptop display and an external monitor, adjust the worksheet view after moving Excel between screens.
Troubleshooting
- The zoom slider or percentage is missing. Maximize the Excel window and look along the bottom-right edge. If the status bar itself is hidden or the window is very narrow, use View > Zoom from the ribbon. In Excel for the web, check the lower-right area of the browser-based workbook window; browser zoom and worksheet zoom are different settings.
- The worksheet still looks too small after changing zoom. Confirm that you changed the worksheet zoom rather than the browser zoom or Windows display scale. Check the percentage shown in Excel, then choose a higher value such as 125% in the Zoom dialog. If only the ribbon looks small, adjust display scaling or the app interface rather than the worksheet zoom.
- The percentage will not go higher or lower. Excel has a supported zoom range, generally 10% through 400%. If an entered value is outside the range, choose a value within it. If the slider seems stuck, click another point on it or use the Zoom dialog to enter a valid percentage.
- Only one sheet changed. This is expected when you adjust the active worksheet. Click each other sheet tab and set its zoom separately if you want matching views. If you select multiple sheet tabs to group sheets, be careful: actions can affect all grouped sheets. Right-click a selected tab and choose Ungroup Sheets when finished.
- The printed sheet did not change. That is expected: zoom is a screen-view setting, not a print scaling command. Use File > Print to inspect the preview and adjust page orientation, margins, paper size, or scaling as needed. Check that the print layout remains legible before printing.
- The view changes again after reopening. Save the workbook after setting the desired zoom and reopen the same file to check. If the file is read-only, shared with restrictions, or opened in a different Excel environment, you may not be able to preserve the view as expected. Also verify that you are opening the same workbook and sheet.
Frequently Asked Questions
Does changing zoom change the size of cells?
No. It changes how large the worksheet appears on screen. Row heights, column widths, cell contents, and print dimensions are not altered by zoom.
Can I set a specific zoom percentage?
Yes. Choose View > Zoom, select Custom, enter the percentage, and click OK. A supported value between 10% and 400% gives you a precise setting.
Can different sheets in one workbook have different zoom levels?
Yes. Select a sheet tab and adjust its zoom, then repeat on any other sheet that needs a different view. A workbook’s sheets do not have to share one percentage.
How do I make the worksheet fit the Excel window?
Select the relevant cells and choose View > Zoom to Selection. Excel will magnify or reduce the view to frame that range. For a fixed percentage instead, use View > Zoom and enter a custom value.
Does zoom affect what other people see when I share the workbook?
Zoom is a view setting, not a change to the underlying data. If you save the workbook, the saved view may be used when it is opened, but another person can change the zoom in their own Excel session. Their display size and Excel environment can also affect how the sheet looks.
Is worksheet zoom the same in Excel for Mac and Excel for the web?
The purpose is the same, but interface details can differ. On Mac, use the status-bar zoom control or the commands on the View tab. In Excel for the web, use its status-bar zoom controls or View options; do not confuse browser zoom with the workbook’s sheet zoom.
Related
- Add a Border to an Image in Excel: Step-by-Step
- Add Color to Excel Data Validation Lists
- How to Add Color to Every Other Row in Excel Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Dynamic Dependent Dropdown List in Excel: How to Build OneTo create a dynamic dependent dropdown in Microsoft 365 Excel, store category and item pairs in an Excel…
- How to Find Duplicate Entries in ExcelTo find duplicate entries in Excel, select the cells you want to check, then choose Home > Conditional…
- Excel Text to Columns: How to Keep Leading Zeros SafelyYes—Excel Text to Columns can keep leading zeros, but you must set the affected column’s format to Text…
- How to Add a Shared Mailbox to Outlook on Any DeviceTo add a shared mailbox in Outlook, first ask your Microsoft 365 or Exchange administrator to grant your…
- Merge Cells in Excel and Keep All DataTo merge cells in Excel without losing their contents, first combine the contents into one cell, then merge…
- Remove an Extra Page After a Section Break in WordTo remove an extra page after a section break in Word, show formatting marks with Ctrl+Shift+8 on Windows…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.