How to Change Zoom Level in Excel: Step-by-Step

This tutorial shows you every way to change the zoom level in Microsoft Excel, whether you need a closer look at cell contents or a bird’s-eye view of a large worksheet. You’ll learn the quick slider method, keyboard shortcuts, the View tab, and how to zoom to a specific percentage or selection.

What You’ll Need

Microsoft Excel (2013, 2016, 2019, 2021, or Microsoft 365 – all have the same zoom controls)
A worksheet with data (optional, but helps you see the effect)

Step-by-Step

Use the Zoom Slider (fastest method) – Look at the bottom-right corner of the Excel window. You’ll see a horizontal slider with a minus sign (–) on the left and a plus sign (+) on the right. Drag the slider right to zoom in (up to 400%) or left to zoom out (down to 10%). The current percentage is shown next to the slider.
Use the Zoom buttons – Next to the slider, you’ll see a percentage number (e.g., “100%”). Click the minus or plus buttons to decrease or increase zoom in 10% increments. Click the percentage number itself to open the Zoom dialog box, where you can type a precise value (e.g., 75, 125, 200) and click OK.
Use the View tab – Go to the View tab on the ribbon. In the Zoom group, you’ll find four options: Zoom (opens the dialog box), 100% (instantly returns to 100%), Zoom to Selection (zooms to fit the selected cells), and Page Layout (switches to page layout view, which automatically adjusts zoom to fit the page).
Use keyboard shortcuts – Press Ctrl + Mouse Wheel to zoom in or out. Scroll up to zoom in, scroll down to zoom out. This works instantly and is the most convenient shortcut. Alternatively, press Alt + W then Q to open the Zoom dialog box (this works in most versions).
Zoom to a specific selection – Select the cells you want to focus on, then go to View > Zoom to Selection. Excel will adjust the zoom percentage so your selected range fills the window. This is ideal for checking a specific data range without manual adjusting.
Zoom in Page Layout view – If you’re working in Page Layout view (View > Page Layout), you can use the zoom slider or the Zoom dialog box as usual. The view will adjust the page size accordingly.
Save zoom settings with the workbook – Excel remembers the zoom level you set when you save the workbook. When you reopen it, the zoom level will be the same. If you want to reset it, simply set it to 100% before saving.

Common Mistakes

Confusing zoom with print scaling – Changing the zoom level only affects the on-screen display, not how the worksheet prints. To adjust print size, use Page Layout > Scale to Fit (e.g., set to 80% of normal size).
Forgetting that zoom is per-window – If you open multiple Excel windows, each has its own zoom level. Changing one doesn’t affect the others.
Using Ctrl+Mouse Wheel accidentally – Many users unintentionally zoom when they meant to scroll. If the screen suddenly zooms, press Ctrl+0 (zero) to reset to 100% (or use the slider).
Zooming to selection with no selection – If you click “Zoom to Selection” without selecting cells, Excel may zoom to the used range or do nothing. Always select a range first.

Tips

Quick 100% reset – Press Ctrl+0 (zero) to instantly reset zoom to 100%. This works in all modern Excel versions.
Zoom with the keyboard only – Use Alt+W then Q to open the Zoom dialog, type a number, and press Enter. This is handy if you prefer not to use the mouse.
Zoom to fit a printed page – If you want to see how your data fits on a printed page, switch to Page Layout view (View > Page Layout) and use the zoom slider. Excel will show you the page breaks and margins.
Custom zoom percentages – The Zoom dialog lets you type any value between 10 and 400. For example, 150% is great for presentations, 75% is good for overviewing large tables.
Use zoom with frozen panes – Zoom works perfectly with frozen panes (View > Freeze Panes). You can freeze headers and zoom in/out without losing the frozen rows/columns.

Troubleshooting

Zoom slider is missing or not working: The slider is always present in the status bar. If it’s not visible, right-click the status bar and check “Zoom Slider” is enabled. If the slider is greyed out, you might be in a mode that doesn’t support zoom (e.g., editing a cell – press Enter to exit edit mode).

Ctrl+Mouse Wheel doesn’t work: This shortcut can be disabled by some add-ins or system settings. Try using the slider or the View tab instead. Also, check if your mouse driver has a special zoom feature that overrides Excel’s.

Zoom resets after reopening the file: Excel normally remembers the zoom level per workbook. If it resets, you may have the workbook set to “Open in a new window” or a template that forces 100%. Check the file’s properties (File > Info > Properties) or try saving as a new file.

Zoom to Selection shows “Cannot compute” or does nothing: This usually happens when the selection is empty or the worksheet is protected. Unprotect the sheet (Review > Unprotect Sheet) if needed, or make a selection first.

Zoom percentage shows “0%” or is stuck: This can occur if you zoom out too far (minimum is 10%). Use the slider to drag back up, or type 100 in the Zoom dialog.

Frequently Asked Questions

Does changing zoom affect printing?

No. Zoom only changes the on-screen view. To change print size, use Page Layout > Scale to Fit (e.g., set to 80% of normal size).

What is the maximum zoom level in Excel?

The maximum zoom is 400% and the minimum is 10%. You can type any value in that range in the Zoom dialog.

How do I zoom to fit all my data on one screen?

Select all your data (Ctrl+A), then go to View > Zoom to Selection. Excel will adjust the zoom so the selected range fits the window. Alternatively, use the slider to manually adjust.

Can I set a default zoom level for all new workbooks?

Yes. Go to File > Options > Advanced, scroll to the “Display” section, and set the “Default zoom for new workbooks” to your preferred percentage. This applies to new workbooks, not existing ones.

Why does my zoom keep changing when I scroll?

This happens if you’re holding the Ctrl key while scrolling. Release Ctrl, and scrolling will move the page instead of zooming. If it still zooms, check your mouse settings.

Is there a way to zoom using only the keyboard?

Yes. Press Alt+W then Q to open the Zoom dialog, type a number, and press Enter. Or use Ctrl+0 to reset to 100%.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →