How to zoom in and out in Excel

To zoom in or out in Excel, move the zoom slider on the status bar at the bottom right. Use the View tab to enter an exact percentage or fit selected cells to the window. View zoom leaves cell values, font settings, and print scaling alone. These steps use desktop Excel for Windows.

Zoom from the status bar

  1. Drag the slider at the bottom right to the right to zoom in or to the left to zoom out. The + and − buttons change the zoom in steps.
  2. Click the current percentage, such as 100%, to open the zoom dialog. Try 125% to read small text or 80% to see more columns. If the percentage or slider is missing, right-click the status bar and enable Zoom and Zoom Slider.

Set a percentage or fit selected cells from View

  1. On the View tab, choose Zoom, enter a custom percentage, and select OK. The separate 100% button on View returns the worksheet to 100% zoom.
  2. To focus on a table, select a contiguous range such as A1:H20, then choose View → Zoom to Selection. Excel adjusts the view to fit the selected cells in the current window while leaving font and cell sizes as they are.

Set zoom on each sheet you want to change. To keep the setting, save the workbook in desktop Excel and reopen it to check. Excel for the web lets you change zoom from the status bar, but it does not save the zoom level.

Microsoft’s guide to setting and saving view zoom

Change zoom quickly with Ctrl and the mouse wheel

If your mouse supports it, hold Ctrl over the worksheet and roll the wheel forward to zoom in or back to zoom out. If the wheel only scrolls or skips past your preferred percentage, use the status bar.

Microsoft’s guide to moving and zooming in an Excel worksheet

Fix small print or columns that don’t fit

If the worksheet looks fine on screen but the printout is too small, press Ctrl+P to open print preview. If fitting the entire sheet on one page made the text too small, review the print scaling or switch to landscape orientation and check again.

To fit all the columns across one page while letting the rows continue on additional pages, go to Page Layout → Scale to Fit and set Width to 1 page and Height to Automatic. Confirm in print preview that the columns fit and the text is readable.

Microsoft’s guide to scaling a worksheet for printing