How To Zoom In Excel?

Albert Howard

Updated on:

how to zoom in excel

While working on an Excel worksheet, have you ever wondered how to zoom in Excel? There are many reasons why you might need to adjust the zoom levels of your Excel workbook. Do not worry if you are unable to adjust Excel zoom levels! In today’s post, I will discuss everything about how to zoom in Excel. Here, I’ll walk you through four methods you can use to get that perfect zoom percentage you need. Make sure you also check out the process of zooming out in Excel. Without wasting much time, let us now find out how to zoom in Excel in more detail.

How To Zoom In Excel?

You can follow these steps to learn how to zoom in Excel.

  1. On your desktop device, launch the Excel app.
  2. Open the workbook where you want to zoom in.
  3. Now, navigate to the bottom menu bar of the workbook. 
  4. Here, you’ll see the Zoom Slider.
  5. Click on the plus + icon beside 100% to zoom in.

However, you can also drag the slider to the right to adjust the zoom level percentage. You can keep on reading further to learn more about how to zoom in Excel sheet.

Also Read N: How To Zoom In On iMovie?

Zoom In Excel Using Keyboard Commands

Most Microsoft programs use the keyboard shortcut commands for zooming in/out. Follow these steps to know how to zoom in Excel using a keyboard.

  1. On your desktop device, launch the Excel app.
  2. Open the workbook where you want to zoom in.
  3. Now, press Control, Alt, and the plus sign to zoom in.

You’ll notice that your Excel sheet is zoomed in by an increment of 10%. 

Also Read P: How To Zoom In On iPad?

Zoom In Excel Using Mouse Scroll Wheel

If your computer mouse has a scroll wheel, then you have the ability to zoom in and out of your Excel spreadsheet. You can follow these steps to learn how to zoom in on a graph in Excel.

  1. On your desktop device, launch the Excel app.
  2. Open the workbook where you want to zoom in.
  3. Now, press and hold the Control key on your keyboard using your left hand.
  4. Place your index finger (right hand) on the mouse scroll wheel.
  5. Scroll the scroll wheel up or forward direction to zoom in.
  6. Release the Control button and your mouse scroll wheel once you’re done.

Note: You can keep pressing the Control button and scrolling the mouse scroll wheel until you reach the maximum zoom in Excel.

Zoom In Excel Using Excel’s Ribbon

You must have noticed some built-in zoom options in Excel’s Zoom section. Follow these steps to know how to zoom in on an Excel graph using Excel’s Ribbon.

  1. On your desktop device, launch the Excel app.
  2. Open the workbook where you want to zoom in.
  3. Now, navigate to the View tab.
  4. Here, search and go to the Zoom section.
  5. You’ll see different Zoom options here including Zoom, 100%, and Zoom to Selection.
  6. When you click on Zoom, a zoom percentage in Excel window will appear.
  7. Select the zoom percentage level of your choice and click on OK.
  8. You can also click on the Zoom to Selection option.
  9. This will zoom the selected cell of your Excel sheet.

This method is great if you want custom magnification. Your workbook will zoom in to fit the current selection.

Zoom In Excel On Mac

Surprisingly, you can also zoom in on Excel on Mac. Simply follow these steps to zoom in Excel with a shortcut on Mac.

  1. On your desktop device, launch the Excel app.
  2. Open the workbook where you want to zoom in.
  3. Now, press Command, Alt, and the plus sign to zoom in.

You’ll notice that your Excel sheet is zoomed in by an increment of 10%.

Zoom In Excel Online

The online version of Excel is slowly adding more features including zoom. You can follow these steps to learn how to zoom in on Excel Online.

  1. On your desktop device, launch Excel Online.
  2. Open the workbook where you want to zoom in.
  3. Now, press and hold the Control key on your keyboard using your left hand.
  4. Place your index finger (right hand) on the mouse scroll wheel.
  5. Scroll the scroll wheel up or forward direction to zoom in.
  6. Release the Control button and your mouse scroll wheel once you’re done.

Excel Online also supports the following ways to zoom in and out on a spreadsheet.

  • Pinch to zoom in on the touch screen/trackpad on the Excel app.
  • Press the Control, ALT, and + keys to zoom in on Excel.
  • Click the + button from the bottom right corner.
  • You can also select a predefined zoom level from 25% to 200%.

Click here – How To Zoom In On Chromebook?

Zoom Out Excel Ribbon

Once you’re done working on your Excel worksheet, you must reset the zoom to 100%. Follow these steps to learn how to zoom out Excel Ribbon.

  1. On your desktop device, launch the Excel app.
  2. Open the workbook where you want to zoom in.
  3. Now, navigate to the View tab.
  4. Here, search and go to the Zoom section.
  5. You’ll see different Zoom options here including Zoom, 100%, and Zoom to Selection.
  6. Select 100%.

This will help you to reset the zoom level of your document back to 100%.

Zoom In Word Using Keyboard

Till now, I hope you’ve understood how to zoom in on Excel. You can also utilize the Zoom function on other Microsoft applications like Word. Follow these steps to learn how to zoom in on Word with a keyboard.

  1. On your desktop device, launch the Word app.
  2. Open the Word document where you want to zoom in.
  3. Now, press and hold the Control key on your keyboard using your left hand.
  4. Place your index finger (right hand) on the mouse scroll wheel.
  5. Scroll the scroll wheel up or forward direction to zoom in.
  6. Release the Control button and your mouse scroll wheel once you’re done. 

If you want to decrease the zoom size, press Control and scroll the mouse wheel down.

So that all About how to zoom in excel.

Get to know more about different topics by visiting Zoominks

FAQ

What Is The Shortcut To Zoom In Excel?

Just hold down the Ctrl key and scroll the wheel up or down. Scrolling up will zoom in, while scrolling down will zoom out. This is a quick and easy way to zoom without having to use your keyboard.

How Do You Zoom In Excel Without Using Mouse?

You can zoom in and out by accessing the Zoom dialog in the Ribbon using the keyboard:

  1. Press Alt. Key tip labels or badges appear on the Ribbon.
  2. Press w to activate the View tab.
  3. Press q to display the Zoom dialog box.
  4. Use the up and down arrow keys to select a zoom level.
  5. Press Enter.

How Do You Zoom In And Out On Your Spreadsheet?

Zoom in or out
On your computer, open a document in Google Docs or a spreadsheet in Google Sheets. In the toolbar, click 100%. Choose how big you want your text or enter a number from 50 to 200. In Google Docs, to make the document as wide as the browser window, click Fit.

What Option Is Used To Magnify And Shrink The Entries In Excel?

When you want to quickly change the magnification of a worksheet, use the Zoom slider. You’ll find the Zoom slider in the bottom right corner of the Excel window. To use the Zoom slider, drag the slider to the right or to the left.

How Do I Increase Screen Size In Excel?

First, you can use the Zoom control at the bottom-right of the Excel window, at the very right-hand side of the status bar. Just drag the control to the left or to the right and Excel adjusts the size of what you see on the screen.

Click here – How To Zoom In On Tik Tok?

Where Is The Zoom Control?

Tap the gear icon in the top-right corner to access in-meeting settings. If you’re using Zoom Rooms for Touch or a Zoom for Home device, tap the ellipses icon (…) at the bottom-right corner of the screen to display the on-screen controller.

How Do I Make The Screen Bigger In Excel?

First, you can use the Zoom control at the bottom-right of the Excel window, at the very right-hand side of the status bar. Just drag the control to the left or to the right and Excel adjusts the size of what you see on the screen.

How Do You Zoom Out On Ctrl Key In Excel?

The Ctrl key is only meant to zoom if you hold it down while rolling the mouse wheel, tapping the + or – key, or scroll the touchpad.

Conclusion

In the above post, I’ve explained how to zoom in on Excel in detail. One of the most utilized methods to adjust the zoom level is using Excel’s status bar. At the bottom of your Excel worksheet, you’ll see a slider. Simply drag the slider or click on the + sign to increase the current Zoom level. You can also go to the View tab to access the Zoom group. Here, you can select Zoom to customize the zoom percentage level according to you. Otherwise, select Zoom to Selection to maximize the selected cells. By learning how to zoom in Excel, you can easily modify the current zoom level.

 

To Know Some Great Stuff Do Visit SnapperNews

To Know Some Great Stuff Do Visit Snorable

To Know Some Great Stuff Do Visit SquareRoott

To Know Some Great Stuff Do Visit StarCasto

To Know Some Great Stuff Do Visit StatusKDuniya

How do I zoom the screen in Excel

How do i Zoom in in Excel?