Join Lorna Daly for an in-depth discussion in this video Customizing the Ribbon, part of Excel 2007 Essential Training.
- View Offline
Now that you've seen what the ribbon offers you, let's take a look at how 2007 Excel let's you customize these lists. For those of you that are old-time Excel users, you're probably wondering, how can I get easy access to those commands that I used to use a lot when I was in 2003, and I knew where they were. Well that's very easy to do. Right at the very top of the screen, you have your drop-down list, and I'm pointing at that drop-down list right now. I'd simply click on that to customize my Quick Access toolbar, and if you take a look to the left, you'll notice that I already have a few icons sitting on that toolbar.
How can I add more? Well, it's very simple. You'll notice that by the Save option here, or the Save command, I have a checkbox. What does that do for me? Well that adds that particular icon, that Save icon, to my Quick Access toolbar. I could say I'd like my spell check, because I'm an awful speller, and I want that easy at hand. By clicking on that, it closes that window and it puts the spell check icon right up on that Quick Access toolbar for me. So by simply clicking on the downward pointing arrow, I can set up my Quick Access toolbar very, very simply.
I could look at more commands, and by clicking on that I pop into the Excel Options tab, to the customized view. And this gives me access to all of the different commands that are in the Microsoft Office menu, as well as in Excel itself. By clicking on the particular tab I'm interested in, it presents me with a drop-down list of all the information that I'd like to be able to work with. I also like the AutoSum features, so I'm going to select that, click on the Add button to move it from the left-hand side of the screen to the right. I can re-order the order that my Quick Access toolbar presents in, by selecting a particular command that I want at the very beginning of my list, and clicking up.
So you see, it's very, very simple for you to have complete control over what you are looking at in the Quick Access toolbar. By clicking on the OK button, you'll notice up in the top here that I have now all my favorite commands, just at the click of a button. One last thing I want to show you that the Quick Access toolbar, is the ability to position it. Right now, it's at the very top above my ribbon. We have one other place that it can be placed, and it's down below the ribbon. So if I prefer to have the Quick Access toolbar closer to my formula bar, I can simply place it below my ribbon.
If I prefer, I can put it back above. So it's really personal preference. If you've placed all of your favorite icons on your Quick Access toolbar, and you really don't want to see the ribbon any longer, you can easily minimize it by again, clicking on the custom Quick Access toolbar, and clicking the minimized ribbon option. And there, it's gone. And for those of you who are true 2003 users, this is a little bit more in tune with what you're used to seeing. Let's bring back the ribbon at the moment because I really want to explore the information that's included on it, so I just simply click on my Quick Access toolbar option, and click on the minimize ribbon to deselect that option, and my ribbon's now in front of me.
Now, we're going to go on to the next movie that allows us to see how we can customize the information behind the Microsoft Office button.