A cool Excel trick from Geert Delmulle - you can increase decimal repeatedly by holding down Alt+1. This works if you move the Increase Decimal icon to one of the first 9 spots on the Quick Access Toolbar.
Table of Contents
(0:00) Fast Way to Increase Decimal in Excel
(0:47) After Alt key, use 1-9 for first 9 QAT icons
(1:02) Hold Alt+2 to run 2nd QAT icon repeatedly
(2:30) Adding icons to the Excel QAT
(2:54) Moving QAT icon to beginning
(3:06) Finding icons not on Ribbon for QAT
(4:06) Save icon too far left after AutoSave removed
Table of Contents
(0:00) Fast Way to Increase Decimal in Excel
(0:47) After Alt key, use 1-9 for first 9 QAT icons
(1:02) Hold Alt+2 to run 2nd QAT icon repeatedly
(2:30) Adding icons to the Excel QAT
(2:54) Moving QAT icon to beginning
(3:06) Finding icons not on Ribbon for QAT
(4:06) Save icon too far left after AutoSave removed
Transcript of the video:
Learn Excel from MrExcel Podcast, Episode 2368.
Hold ALT+1 to repeatedly run QAT Icon 1.
This is a tip that I did not know.
I sort of knew about it, but I didn't understand how it worked.
I'm pretty sure that this tip came from Geert Delmulle. What I did know is that the first nine items in the Quick Access Toolbar have a pretty cool keyboard shortcut.
So I'm going to press and release ALT and allow the key tips to appear.
So you see the numbers 1 through 9 would allow you to run whatever icons you have as the first nine.
And Geert said, "Take the icons you use all the time and move them into that position".
Right?
So I have increase and decrease decimal, I have insert a + sign, and then five and six will be increase and decrease font size.
So in theory here, let's just put a number in here, = Rand.
The way that I thought that this would work is if I wanted to decrease decimals, I'd have to press ALT release and press 2, ALT release and 2.
But no, that's not the fast way to do this.
It turns out if I hold down ALT+2, it will run whatever icon is in that position repeatedly.
So here, I'll just hold down ALT+2.
You see, we get back to one.
Let's make this wider, and I will run increase decimals.
So hold down ALT+1, just keep holding it down and eventually we get so wide, it's wider than the cell.
ALT+2, and we can decrease decimals.
This is pretty cool.
I knew it was ALT release 1, but I didn't realize it was ALT+1, and I didn't realize that I could just hold down ALT and hold down the 1 and it would run it repeatedly.
I was kind of shocked, like I put the + sign here just to test that.
So I hold down ALT+3, I can insert a bunch of + signs.
If I come back here and increase font size, that's going to be ALT+5.
I just hold down ALT+5.
It's larger, and then ALT+6 will make it smaller.
I'm a little surprised.
It's a great tip.
I don't know why I thought I'd have to press and release ALT to pull this off, but very, very cool that you can just hold down ALT+1, ALT+2.
Now, maybe you already knew this.
Maybe this is just so obvious.
Now that I'm talking about it, it's like, well, why wouldn't I have thought that that would've worked?
A lot of things like Open or Clip, you couldn't run these repeatedly.
You couldn't just hold down the icon and run it.
So maybe that's why I didn't know.
I'm not sure.
All right, so now you might be asking, well, how do we add icons to the Quick Access Toolbar and then move them into those one through nine spots?
Okay, so let's say that we want increase decimal.
It's right there.
I'm going to right-click and say Add to Quick Access Toolbar.
And then here, decrease decimal, Add to Quick Access Toolbar.
And anytime you add something to the Quick Access Toolbar like this, it's going to be added to the end.
So right-click, Customize Quick Access Toolbar, find that icon, and then use the up, up, up, up, up, and move it into the first position.
So it's ALT+1.
Decrease decimal is ALT+2.
Now, sometimes you need something that isn't in the ribbon, so then you come here to All Commands.
I'm going to go down and find the little icon that adds a + sign and we will add that.
See it adds to the third spot.
I guess whatever's selected, it adds it right after.
Click Okay.
And then the other two that I want to add...
Yeah, auto save is moot.
Thanks, Microsoft.
We saw that on the MrExcel Podcast.
Right here, we're going to increase font size, so right-click, Add to Quick Access Toolbar and decrease font size, Add to Quick Access Toolbar, and then we'll customize and move both of those into the number three spot and the number four spot.
You'll notice that I have the save icon here.
When they move the auto save icon to the Title Bar, that forced the save button to be a little bit too close to the left margin.
So by me adding it here and kind of putting it in that third spot, my muscle memory is allowing me to see the save icon kind of easier.
All right.
Well, hey, thanks to Geert for sending that awesome little tip in, and thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.
Hold ALT+1 to repeatedly run QAT Icon 1.
This is a tip that I did not know.
I sort of knew about it, but I didn't understand how it worked.
I'm pretty sure that this tip came from Geert Delmulle. What I did know is that the first nine items in the Quick Access Toolbar have a pretty cool keyboard shortcut.
So I'm going to press and release ALT and allow the key tips to appear.
So you see the numbers 1 through 9 would allow you to run whatever icons you have as the first nine.
And Geert said, "Take the icons you use all the time and move them into that position".
Right?
So I have increase and decrease decimal, I have insert a + sign, and then five and six will be increase and decrease font size.
So in theory here, let's just put a number in here, = Rand.
The way that I thought that this would work is if I wanted to decrease decimals, I'd have to press ALT release and press 2, ALT release and 2.
But no, that's not the fast way to do this.
It turns out if I hold down ALT+2, it will run whatever icon is in that position repeatedly.
So here, I'll just hold down ALT+2.
You see, we get back to one.
Let's make this wider, and I will run increase decimals.
So hold down ALT+1, just keep holding it down and eventually we get so wide, it's wider than the cell.
ALT+2, and we can decrease decimals.
This is pretty cool.
I knew it was ALT release 1, but I didn't realize it was ALT+1, and I didn't realize that I could just hold down ALT and hold down the 1 and it would run it repeatedly.
I was kind of shocked, like I put the + sign here just to test that.
So I hold down ALT+3, I can insert a bunch of + signs.
If I come back here and increase font size, that's going to be ALT+5.
I just hold down ALT+5.
It's larger, and then ALT+6 will make it smaller.
I'm a little surprised.
It's a great tip.
I don't know why I thought I'd have to press and release ALT to pull this off, but very, very cool that you can just hold down ALT+1, ALT+2.
Now, maybe you already knew this.
Maybe this is just so obvious.
Now that I'm talking about it, it's like, well, why wouldn't I have thought that that would've worked?
A lot of things like Open or Clip, you couldn't run these repeatedly.
You couldn't just hold down the icon and run it.
So maybe that's why I didn't know.
I'm not sure.
All right, so now you might be asking, well, how do we add icons to the Quick Access Toolbar and then move them into those one through nine spots?
Okay, so let's say that we want increase decimal.
It's right there.
I'm going to right-click and say Add to Quick Access Toolbar.
And then here, decrease decimal, Add to Quick Access Toolbar.
And anytime you add something to the Quick Access Toolbar like this, it's going to be added to the end.
So right-click, Customize Quick Access Toolbar, find that icon, and then use the up, up, up, up, up, and move it into the first position.
So it's ALT+1.
Decrease decimal is ALT+2.
Now, sometimes you need something that isn't in the ribbon, so then you come here to All Commands.
I'm going to go down and find the little icon that adds a + sign and we will add that.
See it adds to the third spot.
I guess whatever's selected, it adds it right after.
Click Okay.
And then the other two that I want to add...
Yeah, auto save is moot.
Thanks, Microsoft.
We saw that on the MrExcel Podcast.
Right here, we're going to increase font size, so right-click, Add to Quick Access Toolbar and decrease font size, Add to Quick Access Toolbar, and then we'll customize and move both of those into the number three spot and the number four spot.
You'll notice that I have the save icon here.
When they move the auto save icon to the Title Bar, that forced the save button to be a little bit too close to the left margin.
So by me adding it here and kind of putting it in that third spot, my muscle memory is allowing me to see the save icon kind of easier.
All right.
Well, hey, thanks to Geert for sending that awesome little tip in, and thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.
