Hi, this is Wayne again with a topic “Trick Out Your Excel Quick Access Toolbar with these Hidden Powerful Features”.
In this Excel video, I will show you how to trick out your Excel quick access toolbar by putting on it the best hidden features in Microsoft, Excel. Let’S get started so here, I’m working in a spreadsheet for an office supply company and of course I can continue to find the features that I need for the most part by just looking at the tabs and the ribbon and from time to time. Maybe going into the groups and using these dialogue box launcher buttons to get even more options and features, and that’s fine, but, as you can tell, sometimes it takes multiple clicks to find the right tool, the right option that you want to select. Why not customize this quick access toolbar so that you can access those tools that you use the most and that are some of the best Excel features, and you can use them just by clicking a button. So in this article we’re going to be working on this area of Excel for the entire video pretty much much, and it’s going to help me supercharge my Excel spreadsheets. The first thing you need to know is how to customize this quick access toolbar. Basically, you just click this button here, customize quick access, toolbar.
You can also just rightclick on the quick access Toolbar to get an option to customize it, but I’ll just click this button here and immediately. I get a list of commonly added tools that people like to add to the quick access toolbar one of the best tools that most people add is this new. So anytime, you need a new workbook in Excel.
You can just click this button and you get a brand new workbook, I’m going to exit out of that workbook to switch back to my original workbook. So what other tools do I recommend adding to the quick access toolbar? Of course, we already have the quick save button and we have an undo button and a redo button and notice that those undo and redo buttons have a little drop- down arrow button just to the side of them. As you make changes in your spreadsheet notice. What happens to that drop down down button when you click on it? It shows you each change that you’ve recently made and you can quickly undo three or four or five or more actions all at once. So I’m going to undo all the way back to this point here, but in addition to those few tools that we already have, and also this new workbook button that I just added the next tool that I’m going to add to my quick access. Toolbar is called paste special now. I don’t see paste special in this list here.
So, in order to get it, I have to go here to more commands and then I can come up here to this drop-down list and it says popular commands, but I’ll click on that and switch to all commands and then I’ll just browse down alphabetically to paste There are several different paste options: I’m just going to go with paste, special I’ll click, add and now paste special will become part of my quick access toolbar, I click okay and there it is paste special. So now, whenever, whenever I copy something, maybe this range of text here, contrl C, to copy? When I go to paste it, I can simply click on the quick access, toolbar paste special and then it brings up all of the many different options I have for pasting. My data, I can paste only the formulas or only the values, only the formats, whatever it might be, I’m going to paste only the formats and it looks like it worked so paste special, I think, is a valuable tool to add to the quick access toolbar, another Powerful tool to consider adding to the quick access toolbar is the select objects tool. Let’S look for it here by clicking on the quick access, toolbar customize button – I don’t see it in the common list, so I’m going to go to more commands all commands I’ll browse down to look for, select objects there. It is I’ll click, add click, okay, and in order to show you how this works, I’m going to first insert a couple of different shapes into my workbook.
So there we have an oval or a circle. How about a triangle and a rectangle? Now, let’s say I decide, I want to change some feature or aspect of the formatting of these three shapes. How could I do that all at once there’s a couple of ways I could do that, but one would be to go up here and click on the select objects button.
Now before I do that, look at my mouse pointer see what it looks like. It looks like a plus sign, but if I go up here and click it changes to just be an arrow. Now that I have the select objects tool chosen, I can click and drag to select multiple objects. Now all three are selected and I can easily go up here to shape format and make adjustments to all three objects at the same time. So this select objects tool is helpful whenever you want to select more than one item and then move them all at once or change the font of all of them at once or the color or delete all of them. At the same time, that’s a handy tool to have on the quick access toolbar.
This next recommended hidden and Powerful tool in Microsoft. Excel that I recommend putting on the quick access. Toolbar will be perfect for many of you. Others may not use it quite as much, but I think it’s worth sharing and that is the copy as picture tool. I’M going to click here on the customize, quick access, toolbar button I’ll go to more commands and this time I’m going to go from popular commands to commands not in the ribbon.
I could also just go to all commands and then I’ll browse down and look for copy as picture tool there. It is copy as picture I click to add it click. Okay. Now you may notice that there is a downside to using the copy as picture tool notice that there’s not a special icon for it, so Excel just puts in this oddl look Circle and it’s the same Circle as paste special.
So once you get your quick access, toolbar set up, you may want to separate the two of these, so that you, in your mind, can remember which one does what, but the the idea here is that you can click and drag to select a range before I Do that I need to unselect this select objects tool now that I’ve done that I can click and drag to select a range, and then I can just go up here and click the copy. As picture button, I can make some choices about the pictures, appearance and format, I’ll just click. Okay. So now I copied that range, not as a range of data but as a picture. So now I can paste that picture and there it is so now I have a picture of some of my data and I can move this.
I can resize it just like any other picture in my spreadsheet. Okay, let’s move on to our next hidden, powerful tool to consider adding to your quick access toolbar, and that is the close all button. I’M just going to click here to customize my quick access, toolbar, I’m going to go down here and choose more commands and I’m going to switch from popular commands to all commands and browse down. Looking for close all there, it is, I can click, click on it and add it to my quick access: toolbar click.
Okay. So now let’s say I end up opening multiple spreadsheets, multiple workbooks, and maybe I make some changes to some of them, but not others, but I end up with multiple workbooks open cluttering up my desktop at the end of the day. I may just want to close all of these all at once, rather than clicking seven times to close all of them, so I could just click up here on the close all button, I’m going to get some warnings if I haven’t saved my workbooks so now that I’Ve saved the unsaved workbooks, all of the workbooks now have closed, and I just have a shell here of Microsoft Excel and, of course, I could easily click this button here to close out of excel itself. The next powerful hidden tool that we’re going to add to the quick access toolbar is view grid lines. So I’m going to click on more commands I’ll go back up here and change it to all commands and I’ll look for view grid grid lines. Let’S see if we can find it there, it is view grid lines, I’ll click to add it to the quick access. Toolbar click, okay – and let’s test this out so now that I’ve added this view grid lines button to the quick access toolbar. If the grid lines that you see in Excel bother me, I can just at any point click that button to hide them.
Some people love this cleaner, look in Microsoft, Excel honestly. For me, the grid lines don’t bother me, but there are times when I want to hide them. So this is a tool to add to the quick access toolbar and the final hidden, powerful tool that I’d recommend adding to the quick access toolbar, especially if you use a lot of text rather than numbers in your spreadsheets is spell check. So I’m going to go here to all commands and I’ll browse down and look for spell check there.
It is spelling, I’ll click, add click. Okay! Now, anytime, I need a spell check. I can just click that button and begin to spell check now.
I hope that you’ll take the time to look at the other Comm commands in Microsoft, Excel that you can add to the quick access toolbar, because I’ve only just grazed the surface of what’s available here. Each of these tools in this giant list could be added to your quick access, toolbar, and some of these tools will be more important to you and more useful to you than they are for me, so definitely check it out. Also, once you’ve got your quick access bar with all of the tools that you need and want quick access to, like I mentioned before, it may be a good idea to separate some of these tools put in the order.
That makes the most sense for you, and you can do that just by selecting them here at the right and then using these arrows to put them in the right order for you and then just click. Okay, thanks for watching this video, I hope you found it to be helpful. If you did please like follow And subscribe, and when you do click the Bell so you’ll be notified. When I post another video, if you’d like to support my channel, consider clicking the thanks button, you can also support me through my patreon account, and by buying Channel merch and you’ll, see information about those options in the description below the video video .