Skip to content

Zoom In and Out in Excel

In this article, I want to talk about a simple technique that you can use in Microsoft Excel that can potentially make analyzing your data a whole lot easier.

And that is simply the technique of zooming in and out of your Excel worksheet.

How to Zoom in Excel

To change the zoom level of your current Excel worksheet, click on the plus and minus icons near the bottom-left corner of your workbook.

When you click on the minus, you zoom out and make everything a little smaller. When you click on the plus, you zoom in and make everything a little larger.

You can also click on the small vertical zoom bar and drag it to the left or right to zoom out or in.

On top of that, you can zoom by holding the CTRL key on your keyboard and using the scroll wheel on your mouse.

Microsoft Excel will allow you to adjust the zoom level down to 10% or up to 400%. 

Also, adjusting the zoom level will only affect the currently selected worksheet. And the zoom level for that worksheet will stay the same even after you’ve saved, closed, and re-opened your workbook.

Why You Should Zoom

Why should you zoom in and out in the first place? Although it might seem a little strange at first, using the zoom feature can be really useful.

Don’t strain your eyes if you need to take a closer look at a specific section of your worksheet. Just zoom in and take a closer look.

Also, if you need to see the bigger picture, zoom out to see more at once.

On top of that, some may have a tougher time looking at a screen, especially for an extended amount of time. So change the zoom to make looking at the spreadsheet a little easier on the eyes.

The zoom feature is something in Excel that is very easy to use. But it is seemingly not used very often.

Break out of the non-zoom practice and experiment with it from time to time. You might just find that it makes your job a whole lot easier overall!

This Post Has One Comment

  1. I remember when I first encountered a zoom worksheet. I didn’t know what was going on! But now it’s such a great tool I use in my work! I couldn’t recommend it enough!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top