Do you hate the Zoom control on the standard toolbar? If you have a wheel mouse, there is a much faster way to zoom in and zoom out. Episode 496 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey welcome back to the MrExcel netcast.
I'm bill Jelen.
Well hey, it's Friday.
Have a really simple trick for you today.
I was reminded of this trick when I was in Springfield, Missouri at the IMA seminar.
There someone pointed it out and I had once known this, but it's so much easier, and I wanted to pass it along.
In Excel, when we want to zoom in or zoom out, we tend to use this zoom box, up here in the Standard Toolbar.
And it's a little bit frustrating.
It only has a few different options.
You can go 75 or 50 or you know 200 or if that's not going to work, You're gonna have to type in something custom 155.
It's just generally a frustrating thing to do it, but if you have a mouse that has a scroll wheel at, there's a much much easier solution.
Basically, that scroll wheel will usually scroll up and down the worksheet.
But if you hold down the CTRL key while use the scroll wheel, you can infinitely zoom in or zoom out just by using the wheel on the mouse.
Again, Let's hold down the CTRL key while using the scroll wheel in the mouse, you can very quickly zoom in or zoom out.
Not just to the values that they have selected and you don't have to type your own.
You can basically, just scroll until it gets.
To be about the right size that you need and then let go and you're all set.
So, thanks for the folks in Springfield, Missouri.
Who had me out this week for a Power Excel seminar there and for passing that trick along.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
I'm bill Jelen.
Well hey, it's Friday.
Have a really simple trick for you today.
I was reminded of this trick when I was in Springfield, Missouri at the IMA seminar.
There someone pointed it out and I had once known this, but it's so much easier, and I wanted to pass it along.
In Excel, when we want to zoom in or zoom out, we tend to use this zoom box, up here in the Standard Toolbar.
And it's a little bit frustrating.
It only has a few different options.
You can go 75 or 50 or you know 200 or if that's not going to work, You're gonna have to type in something custom 155.
It's just generally a frustrating thing to do it, but if you have a mouse that has a scroll wheel at, there's a much much easier solution.
Basically, that scroll wheel will usually scroll up and down the worksheet.
But if you hold down the CTRL key while use the scroll wheel, you can infinitely zoom in or zoom out just by using the wheel on the mouse.
Again, Let's hold down the CTRL key while using the scroll wheel in the mouse, you can very quickly zoom in or zoom out.
Not just to the values that they have selected and you don't have to type your own.
You can basically, just scroll until it gets.
To be about the right size that you need and then let go and you're all set.
So, thanks for the folks in Springfield, Missouri.
Who had me out this week for a Power Excel seminar there and for passing that trick along.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
