While working with data in Excel, you might need to have closer look at it or maybe you want to have look at large data set in your Excel window. In this scenario, you need to use Zoom-In and Zoom-Out options.
In this tutorial, we will look at both options of zooming in detail.
Steps to Zoom in and out through Ribbon
In Excel, you can easily zoom in and out of the worksheet by using the View tab. To do this, follow the below steps.
- First, go to the “View” tab in the ribbon and then click on the Zoom group.
- After that, click on Zoom and it will open the dialog box on the worksheet. In this, you can choose any existing percentage options or select the custom option to enter the percentage that you want.
- Once you select the percentage, click on OK to apply it.
- The second option is 100% which helps you to zoom your spreadsheet to 100% in a single click.
Zoom to Selection
In Excel, this function is used to zoom the sheet as the selected range of cells fills the entire window. By this, you can easily focus on a particular area of the sheet. Now, follow the below steps.
- First of all, select the cell or range of cells where you want to focus.
- Then, click on the “Zoom to Selection” option from the zoom group.
- Now, the selected range of cells will cover the whole window and you can see this in the following image.
Zoom In and Out by Using the Mouse
Another method to zoom in and out is through the mouse. You have to simply hold the CTRL key of your keyboard and scroll the mouse wheel forward to zoom in and backward to zoom out of the Excel worksheet.
It allows you to increase or decrease by 15% with a single scroll.
Keyboard Shortcut to Zoom in and out
Here, we have provided you the keyboard shortcut keys to zoom in and out of the worksheet quickly. Now, the shortcut keys are:
- Zoom In: CTRL + ALT + +
- Zoom Out: CTRL +
Zoom In and Out through Slider
This is the frequent-use option for Excel users, and it is visible on the right-side corner of the status bar.
- The zoom slider has (-) (+) these two keys that can be used for “Zoom out” and “Zoom in”.
- Zoom out is used to reduce the size of the sheet where you are working on. Whereas Zoom-in helps you to have a close look at the data.
- Moreover, you can also adjust the visibility of the page by sliding the central zoom key in both directions.
Note: It increases or decreases by (10%) once you press the zoom in (-) or zoom out (+) keys.
Zoom by Percentage
In Excel, the zoom percentage is also working the same as the zoom slider. It can be seen next to the zoom slider on the left side of the status bar.
Once you click on it, it will show you a zoom dialog box and from there you can set the magnification percentage for the current worksheet where you are working on.
Points to Remember
- Once you select the zoom-in or zoom-out option, it will only zoom in and out of the current worksheet, and the other spreadsheets will remain the same.
- If you want to zoom in and out the multiple spreadsheets at a time. For this, first, you have to select all the sheets and then use the zoom-in or zoom-out shortcut from the keyboard.
- Excel Fill Justify
- Formula Bar in Excel
- Add a Header and Footer in Excel
- Show Ruler in Excel
- Fill Handle in Excel
- Format Painter in Excel
- Quick Access Toolbar in Excel
- Status Bar in Excel
- Insert Text Box in Excel
- Change Tab Color in Excel
- Excel Options (Mac and Windows)
- Dialog Box in Excel
- Freeze Panes in Excel
⇠ Back to Microsoft Excel Basics (Components, Parts, and Knowledge Notes)