Hi, this is Wayne again with a topic “Zooming in and Out in Excel”.
In this short excel tutorial, I will show you how to quickly and easily change the zoom level in Excel many times when you’re in Excel. You need to zoom in or zoom out in order to see all of your data, or at least more of your data, or maybe you want to zoom in and look at the data in more depth and more clarity, so being able to zoom in and out Is important, probably the most cumbersome way to zoom is to go here to the View. Tab look at the view ribbon, there’s a zoom group and you can quickly zoom to a hundred percent. You can also zoom to selection. So let’s say I have the cells selected.
This range, I can click zoom to selection, and now just that range is zoomed in so that that’s all that I can see that’s kind of a nice feature. You can also click this zoom button here and say you would like 200 % magnification or you could go down to 50 or 25 %, and you can also put in a custom magnification, let’s say 55 percent. So those are all really good options here in the zoom group on the view ribbon, I’m gon na go back to 100 %. The problem with those options is that they’re just a little bit cumbersome like I said before you have to click on View. Then you have to click on the option, then you have to click a number, and so fortunately, Microsoft has added into Excel a quick zoom bar here in the lower right corner. There’S a handle there and I can just quickly click and drag and I can jump to let’s say 218 percent.
Now everything looks nice and big. I can also quickly zoom down, let’s say 250 or 60 %, and so that is a very handy slider. There is yet another option, though, for zooming and many people like this the best and that is to simply hold the ctrl key on the keyboard and then use the scroll wheel on your mouse to scroll forward that zooms in or to scroll downward, and that will Zoom you out now, if you look closely, it is kind of choppy and almost confusing to watch. If you don’t want it to be that way, you can click on cell a1, and now it should zoom in and out much more smoothly. It’S just a lot more smooth with the data that you have if you’re zooming from the a1 cell, so those are three options: three ways to change the zoom level in Excel.
Hopefully it helps you to look at your data more easily and see what you want to be able to see thanks for watching. I hope you found this tutorial to be helpful. If you did, please click the like button below and consider connecting with me on my social media accounts like Facebook, Pinterest and Twitter, and definitely do subscribe to my youtube channel for more videos about technology for teachers and students and when you do subscribe, click the bell.
Next to the subscribe button, if you do that, you’ll be notified whenever I post another video and watch for another video from me at least every Monday. If you’d like to support my channel, consider becoming a supporter of mine through my patreon account and you’ll see a link to that in the description below .