Excel 2010 offers a variety of ways to zoom waaaaay in or waaay out. Today, in Episode #1295, Bill uses the MrExcel Podcast to take a look at zooming in Excel 2010. Zoom in +10% increments, -10% increments, use the Control Key and the Mouse Wheel, use the Zoom Dialog to set a precise zoom percentage... Episode #1295 shows you how.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Rev Up To Excel 2010, chapter 10: Zoom.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Let me talk about Zooming today.
Zooming in, Zooming out. All kinds of different ways of Zooming.
Well, first off, if you have a mouse that has a wheel, you know they're just a great trick here if you hold down Ctrl and scroll the wheel up, you zoom in. Scroll the wheel down, you zoom out. All right, that works in all of the Office programs. So, it's probably a lot better way to go. I've started using the Ctrl and wheel to zoom in and out. Don't have to worry about what setting you want but let's talk about Excel 2010 and the Zoom slider down here at the bottom of the screen but on the screen, okay there's several different controls down here. The plus will Zoom In, in ten percent increments.
So, you start out a hundred percent. Zoom all the way into four hundred percent and see one cell really, really well or the minus will zoom out in ten percent increments. All the way down to ten percent, where I can see, wow! A whole bunch of pages all at once or you just can't get, make anything out between, now if you get to the point where you want to zoom somewhere between 90 and a 100, then you can actually grab the zoom slider itself and zoom to individual. Gotta nudge there on stop.
nudging very well for me.
Nudge the various individual settings in between. Seems to wanna go back to 100 though, if you can't get to where you want to be, I want to be at 93. Actually, click on the number and you get back to, there it is, the Excel 2003 Zoom dialog box, where you type in that I want exactly ninety-three percent or even fit selection. So lots of different options are on the Zoom but don't forget my favorite, hold down the Ctrl key and scroll that wheel mouse to zoom in and out to exactly whatever you're you're looking for. Jumps in, actually it looks like it jumps in fifteen percent increments there, all right.
Oh, hey, I wanna thank you for stopping by.
See you next time for another netcast from MrExcel.
Rev Up To Excel 2010, chapter 10: Zoom.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Let me talk about Zooming today.
Zooming in, Zooming out. All kinds of different ways of Zooming.
Well, first off, if you have a mouse that has a wheel, you know they're just a great trick here if you hold down Ctrl and scroll the wheel up, you zoom in. Scroll the wheel down, you zoom out. All right, that works in all of the Office programs. So, it's probably a lot better way to go. I've started using the Ctrl and wheel to zoom in and out. Don't have to worry about what setting you want but let's talk about Excel 2010 and the Zoom slider down here at the bottom of the screen but on the screen, okay there's several different controls down here. The plus will Zoom In, in ten percent increments.
So, you start out a hundred percent. Zoom all the way into four hundred percent and see one cell really, really well or the minus will zoom out in ten percent increments. All the way down to ten percent, where I can see, wow! A whole bunch of pages all at once or you just can't get, make anything out between, now if you get to the point where you want to zoom somewhere between 90 and a 100, then you can actually grab the zoom slider itself and zoom to individual. Gotta nudge there on stop.
nudging very well for me.
Nudge the various individual settings in between. Seems to wanna go back to 100 though, if you can't get to where you want to be, I want to be at 93. Actually, click on the number and you get back to, there it is, the Excel 2003 Zoom dialog box, where you type in that I want exactly ninety-three percent or even fit selection. So lots of different options are on the Zoom but don't forget my favorite, hold down the Ctrl key and scroll that wheel mouse to zoom in and out to exactly whatever you're you're looking for. Jumps in, actually it looks like it jumps in fifteen percent increments there, all right.
Oh, hey, I wanna thank you for stopping by.
See you next time for another netcast from MrExcel.
