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 gonna 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

Channel: Technology for Teachers and Students

Views: 106,887

Keywords: zooming in excel, how to zoom in excel, how to zoom out in excel, zooming out in excel, shortcut for excel, excel shortcuts, shortcut for zooming in excel, shortcut for zoomin in in excel, shortcut for zooming out in excel, excel zooming for dummies, excel tutorial, let's zoom in excel

Id: wG3F-3qBFQk

Length: 3min 5sec (185 seconds)

Published: Mon Jan 13 2020