Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
An important element in the Excel menu toolbar system is what we call the Quick Access toolbar, and its standard location is above the Ribbon at the top of the screen, upper-left corner here. Now, if you right-click any place within the Quick Access toolbar, you will see a choice here, Show Quick Access toolbar Below the Ribbon, watch what happens. I actually prefer this location myself, but that's a one-time thing.
You might try that for a while. If you don't care for it, what? Right-click and Show Quick Access Toolbar Above the Ribbon. Now, the other thing you probably want to do with this, and you can do this pretty freely and casually, and I've never really explored how many buttons we actually could get here on the screen, but recognize the idea that as you use different tabs in Excel, if there is a feature or a command that you don't see here at the moment, you might have to go back to another tab to get to it. If I want to do underlining right now and I don't know a keystroke shortcut for it, I've got to go back to the Home tab and any button that is here visible at anytime in the Ribbon could be on your Quick Access toolbar all the time.
All you have to do is to right-click on it. So for example here, maybe it's Italic or maybe I change fonts a lot and I'm not always on the Home tab, what might we do? Right-click any button and add it to the Quick Access toolbar. It's going to stay there indefinitely until you change it. You can do that freely and easily with lots of buttons. You can also right-click any toolbar and choose Customize Quick Access Toolbar.
And here's a list of popular commands, see them in here. That's not a huge list. Many of these are already on existing buttons that you see in the menu system, We can just pick any one we want, maybe this one just as an example here, click Add. We see it in the list. Now, while we're here we might also consider how the order of these is. The top-down order that we see here corresponds with the left to right order on the actual Quick Access toolbar.
So here and there you might want to reposition some of these and maybe you think that this is more important than Font Color, so we'll move it up for example. Something like that. Now, don't overlook the fact that when you are customizing using this approach and all we do was a right- click and customize, right-click on the Quick Access toolbar, Customize. This shows popular commands. I'm not really counting. It looks like about 25, 30 of them, whatever. There is another choice here called Commands Not in the Ribbon. This looks like a few hundred.
Now any one of these and in a similar way can be on your Quick Access toolbar as well, and there's quite a few choices there. And you might agonize over the fact that there are too many, but you can choose this one or that one. And believe it or not, there is a third choice here, the drop arrow, All Commands, and I'm guessing here but I think this is about a thousand choices and you see just an amazing number of entries here. So any one of these can be a button on your Quick Access toolbar.
All you've go to do is you've made the decision already, say why I use that a lot or I might use that a lot. There is one, okay, add that to the Quick Access toolbar, click OK. So you can do that freely and easily. If you decide later you don't really need that button, then simply right-click and remove from the Quick Access toolbar. So you're in charge of it. It's easy to add buttons to it. It's easy to take them off, and you can do it in a variety of different ways.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.