How to Zoom In and Out in Excel (4 ways)

This guide will show you how to zoom in and out in Excel in 4 different ways. The zoom in and out in Excel is a key feature that lets users adjust the magnification of their worksheet for optimal viewing and usability. The Microsoft Excel provides various ways to control the zoom level. Below are the 4 ways or methods to zoom in and out in Microsoft Excel:

Method 1: How to Zoom In and Out in Excel using Zoom Slider?

• Go to the bottom-right corner of the Excel window, next to the page layout icons, to find Zoom Slider.
• You’ll see a slider with a minus (-) button on the left and a plus (+) button on the right.
• Click the minus (-) button to zoom out (reduce the size of the worksheet view) or plus (+) button to zoom in (increase the size of the worksheet view) incrementally.
• Alternatively, you can drag the slider to the right to zoom in Excel or drag to the left to zoom out Excel.

Method 2: How to Zoom In and Out in Excel using View Tab?

• Navigate to the View tab on the Ribbon at the top of the Excel window, which provides options for precise zoom control.
• In the Zoom group, you will find the following options:
  • • Zoom: Opens a dialog box where you can select predefined zoom levels (e.g., 25%, 50%, 100%, 200%) or enter a custom percentage.
    • 100%: Resets the zoom level to the default 100%.
    • Zoom to Selection: Adjusts the zoom level to fit the currently selected cells in your worksheet.

Example:

If you want a custom zoom level, then click the Zoom button in View tab. In the Zoom dialog box, type your desired percentage (e.g., 150%) and click OK.

Method 3: How to Zoom In and Out in Excel using Keyboard and Mouse?

This is one of the quickest ways to zoom in and out if you have a mouse with a scroll wheel. This method allows you to adjust the zoom level dynamically without navigating through menus. Follow the below steps to zoom in and out in Excel using the keyboard and mouse shortcut:

• Hold down the Ctrl key on your keyboard.
• While holding Ctrl, use the scroll wheel on your mouse:
  • • Scroll up to zoom in (make everything larger).
    • Scroll down to zoom out (make everything smaller).

Method 4: How to Zoom In and Out in Excel using Shortcut Keys?

Below are the keyboard shortcut keys to Zoom in or out in Excel:

*Press the plus sign (+) or minus sign (-) from the numeric keypad of the keyboard. If the numeric keypad is not available, then press the Ctrl + Alt + Equal sign (=) to zoom in.

Conclusion

The zoom in and out in Excel is a simple yet essential feature that enhances your workflow and viewing experience. By adjusting the zoom level using the slider, View tab options, or keyboard shortcuts, you can seamlessly navigate between detailed data analysis and an overall summary view. This flexibility allows you to tailor your workspace, ensuring clarity and precision in managing your spreadsheets.

Learn More