Microsoft Excel Zoom Out: Ways to Shrink the View

How-to basics · Updated November 20, 2026

To zoom out in Microsoft Excel for Microsoft 365 on Windows, click the minus sign beside the zoom slider at the bottom-right of the Excel window, or drag the slider toward the minus sign. You can also choose View > Zoom and select a smaller percentage. Zooming changes how large the worksheet appears on your screen; it does not change the worksheet’s cell values or the size of printed content.

Quick ways to zoom out

The status bar is usually the fastest way to adjust the view while you work. Look in the lower-right corner of the Excel window for a percentage, a minus sign, a slider, and a plus sign. Click the minus sign to reduce the zoom in increments, or drag the slider’s handle left. The displayed percentage updates as you adjust it.

For a specific zoom level, open the View tab and use the Zoom controls. The Zoom command opens a dialog with preset percentages and a Custom option. This is useful if you need an exact setting, such as 80%, rather than repeatedly clicking the minus button.

  • Small adjustment: Click the minus sign on the status bar once or more.
  • Exact percentage: Choose View > Zoom, enter a custom value, and confirm.
  • Return to normal size: Click the percentage on the status bar, if available, or choose View > Zoom > 100%.
  • Fit selected cells: Select the cells, then choose View > Zoom > Zoom to Selection.

In Excel for Windows, holding Ctrl while rotating the mouse wheel down also zooms out in many standard worksheet views. If that gesture does not work on your computer, use the status bar or ribbon; mouse and touchpad settings can affect wheel behavior.

What worksheet zoom changes

Zoom is a display setting for the worksheet window. At a lower percentage, cells, text, and other worksheet contents appear smaller, so more rows and columns fit on screen. At a higher percentage, fewer cells fit, but their contents are easier to inspect. For example, reducing a sheet from 100% to 75% can make a wide table easier to view without hiding columns, although the text may become harder to read.

Zoom does not rewrite cell contents, alter formulas, resize the actual rows or columns, or change the workbook’s print scaling. It is not the same as changing the font size: reducing zoom makes the whole sheet look smaller on screen, while changing font size changes how the cell text is formatted and may affect row height or printed appearance. It also does not create more worksheet cells; it simply changes how many of the existing cells are visible at once.

Zoom applies to the worksheet view, not uniformly to every part of Excel’s interface. The ribbon, formula bar, and dialog boxes do not shrink just because the worksheet is zoomed out. If the entire Excel window and other apps look too large, check Windows display scaling or screen resolution rather than relying on worksheet zoom alone.

Choosing a useful zoom level

There is no single best percentage for every workbook. The right setting depends on screen size, viewing distance, text size, and what you are doing. A large monitor can often show more columns comfortably at 80% or 90%; on a smaller laptop display, 100% or more may be easier to read. These are starting points, not rules, because display dimensions and individual preferences vary.

  • Reading or editing text: Choose a percentage at which you can read cell entries without leaning toward the screen. If text is still too small at 100%, increase zoom or consider a larger font.
  • Reviewing a wide table: Zoom out enough to see the relevant columns together, but keep headings and values legible.
  • Checking a dashboard: Try a lower zoom to see more of the layout at once, then zoom in to read labels or inspect details.
  • Presenting a sheet: Select a comfortable zoom before sharing your screen. A setting that fits your monitor may be too small for viewers on a video call.

Excel’s Zoom dialog lets you use a custom percentage, and the standard zoom range is 10% to 400%. The extremes are rarely practical: at very low zoom, text can be difficult to read, while at very high zoom only a small portion of the sheet is visible. If you need to compare distant areas, use split panes or open another window rather than making the whole sheet extremely small.

Fit a selected range to the window

Zoom to Selection is helpful when you want Excel to frame a particular block of cells. Select the range you want to inspect, then choose View > Zoom > Zoom to Selection. Excel adjusts the zoom so the selected range fills as much of the worksheet window as it can. This can be convenient for a chart source table or a compact report embedded in a larger sheet.

For example, if a report occupies cells B2:G18 but the worksheet extends far beyond it, select B2:G18 and use Zoom to Selection. Excel enlarges or reduces the view to show that range prominently. The resulting percentage may be different from the one you had before. To go back to a familiar view, select View > Zoom > 100%, or adjust the status-bar slider.

Zoom to Selection changes the view, not the selection’s dimensions or print layout. It may also be less useful for a range that is unusually tall or wide: fitting the entire selection can make one dimension quite small. In that case, select only the rows or columns you need to compare, or set a custom percentage instead.

Zoom settings across sheets and windows

Zoom is associated with the worksheet view, so different sheets in a workbook can be displayed at different percentages. You might keep a summary sheet at 100% for reading and set a wide data sheet lower so more fields are visible. When you switch sheets, Excel can display each at its own saved view setting. Save the workbook if you want your view changes to be retained for later sessions.

Be aware that changing zoom while multiple worksheets are grouped can affect more than the active sheet. Grouped sheets are indicated by their selected tabs; right-click a selected sheet tab and choose Ungroup Sheets when you want to edit just one sheet. This avoids making an unintended view change across several worksheets. The setting is a convenience, not a substitute for arranging sheet content consistently for colleagues who open the file on different screens.

Zoom is different from print scaling

A common misunderstanding is that zooming out will make a printed worksheet fit on fewer pages. It will not. Worksheet zoom controls the on-screen view, while print size and page breaks are controlled through print settings. If a sheet looks small on screen but prints across several pages, changing the zoom percentage alone will not solve that problem.

To review print layout, use File > Print and examine the preview. To change how much fits on a printed page, use the scaling options in the print settings, such as fitting the sheet to a page, or adjust the page orientation, margins, and print area. Fitting a very wide or long sheet onto one page can make the printed text too small, so check the preview before printing. You can also use the Page Layout tab’s Scale to Fit options to adjust printed width and height.

Likewise, zooming out is not the right fix if columns are genuinely too narrow or row heights are too large. Change the column width or row height when you want the layout itself to change. Use zoom when you only want a different on-screen view.

Common problems and fixes

If the zoom controls are missing, first check whether the status bar is visible at the bottom of the Excel window. The View tab’s Zoom commands are an alternative. If the window is maximized or the display is crowded, the slider may be difficult to notice; widening the window or using the ribbon can help. The status bar can also be customized, so a particular indicator may not appear in every layout.

  • The sheet is tiny after zooming: Click the percentage and set it back to 100%, or use the plus sign to increase the view gradually.
  • Only one sheet looks different: Select that worksheet and set its zoom separately; zoom is not necessarily a workbook-wide setting.
  • Everything in Excel looks too large: Worksheet zoom will not shrink the ribbon or Windows interface. Review Windows display scaling and Excel’s window size.
  • Text is still hard to read: Increase zoom, widen the relevant columns, or adjust the font size. Avoid making the whole sheet tiny just to fit every column.
  • The mouse wheel changes the wrong thing: Use the ribbon or slider instead, and check whether Ctrl is being held as intended.

If the sheet appears unexpectedly magnified or reduced after opening a file, set a known percentage with View > Zoom. The display percentage is independent of the underlying data, so correcting the view will not undo edits or remove information.

Excel for Mac and Excel for the web

In Excel for Mac, use the zoom controls in the status bar or the Zoom command on the View tab. The precise arrangement can vary with the Excel window and version, but the same principle applies: choose a percentage or adjust the slider. Mac keyboards do not use the Windows Ctrl key in the same way, so do not assume a Windows mouse-wheel shortcut will work identically; the visible controls are the dependable option.

Excel for the web also provides zoom controls, though its location and available commands can depend on the browser window and current interface. Browser zoom is separate from worksheet zoom. If you use the browser’s zoom command, it enlarges or reduces the Excel page and its interface; Excel’s own zoom changes the worksheet view within that page. When the ribbon or browser controls look wrong, restore browser zoom separately rather than changing the worksheet percentage repeatedly.

Frequently Asked Questions

What is the shortcut to zoom out in Excel?
On Windows, Ctrl plus scrolling the mouse wheel down can zoom out in a worksheet view. The status-bar minus button and View > Zoom are more dependable alternatives. Shortcuts and wheel behavior can vary with hardware and settings.

How do I get Excel back to 100% zoom?
Choose View > Zoom > 100%, or click the zoom percentage near the bottom-right of the window and select or enter 100%, depending on the controls shown. This changes the worksheet’s on-screen view only.

Does zooming out change how Excel prints?
No. Worksheet zoom does not set print size. Use File > Print or the Page Layout tab’s Scale to Fit options to manage printed pages, and check the print preview to make sure the result remains readable.

Can I zoom out on only one Excel worksheet?
Yes. Worksheets can have different zoom levels. Select the sheet you want to adjust and change its zoom. If several sheet tabs are grouped, ungroup them first to avoid applying changes across the group.

Why does the Excel ribbon stay large when I zoom out?
Worksheet zoom affects cells, not the ribbon or the whole application window. To change the overall interface size, adjust your display scaling or browser zoom as appropriate; those settings are separate from Excel worksheet zoom.

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.