Robert asks how I get the custom toolbar below my Excel 2007 ribbon. This is the Quick Access Toolbar. In Episode 843, I will show you how to customize this toolbar in Excel 2007.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Okay, here we are, it's another "Where Is It Wednesday", thanks to George Wood for that great theme.
We had a question sent in today by Robert.
Robert was watching one of the old Podcasts, he said, "Hey, what the heck is this below the ribbon?
How did you manage to customize the toolbar?
We can't customize toolbars anymore." Well, that's something called the Quick Access toolbar, and it doesn't start out here.
When you first launch Excel 2007, it appears above the ribbon and it only has three icons-- it has Save, Undo, and Redo.
That's it.
So here's what you're going to do: When you fire up Excel 2007 or Word 2007 or PowerPoint 2007, first thing we want to do is right-click, right-click and say Show this below the ribbon.
That gets it closer to our document, number one, it also gives us a lot more space.
You can get about 50 icons going across instead of running into the title bar up here.
So a lot more space for the icons to be.
Now, how do we customize that?
There's two ways.
First way is if you find something really cool, like the data bars, what we can do is right-click and say Add Gallery to Quick Access Toolbar.
So right-click on whatever you like and it adds it to the toolbar.
And so now, I can add data bars with a single click instead of having to go hunt for it.
Now, the better way to go, though, is to use the Office button and go into Excel Options, choose Customize, and now we can find Commands.
I always like to go into Commands not in the ribbon-- those are things that you'll never find in the ribbon-- and basically I just find it here in the list, it's alphabetical.
Isosceles triangle, add, and we've now added that icon to the ribbon.
And something brand-new in Excel 2007 is we can now add icons to a specific workbook.
So I only want, in Book 1, I want to have the inside borders and the horizontal borders only to appear when this workbook's open.
So now, those two icons only show up when this workbook's open; other workbooks will just have the core set of icons here.
So you can add, you know, about 50 favorite icons going across there.
Several advantages.
One advantage is, you know, normally we're jumping back and forth from Home to Data, Home to Data, and you can only see half the icons at one time from those toolbars-- take the icons use all the time and just add them to your toolbar.
So, that way, you can very quickly access those.
Now, you'll notice that the workbook specific icons always appear at the end of the list.
So as you add more icons to the general Quick Access Toolbar, they will always appear before the workbook-specific icon.
So, great question from Robert: How do we customize that Quick Access Toolbar?
A couple of things: First of all, you need to right-click to get it down below the ribbon; and then right-click any icon to add it to the QAT.
Well, hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
[ music ]
We had a question sent in today by Robert.
Robert was watching one of the old Podcasts, he said, "Hey, what the heck is this below the ribbon?
How did you manage to customize the toolbar?
We can't customize toolbars anymore." Well, that's something called the Quick Access toolbar, and it doesn't start out here.
When you first launch Excel 2007, it appears above the ribbon and it only has three icons-- it has Save, Undo, and Redo.
That's it.
So here's what you're going to do: When you fire up Excel 2007 or Word 2007 or PowerPoint 2007, first thing we want to do is right-click, right-click and say Show this below the ribbon.
That gets it closer to our document, number one, it also gives us a lot more space.
You can get about 50 icons going across instead of running into the title bar up here.
So a lot more space for the icons to be.
Now, how do we customize that?
There's two ways.
First way is if you find something really cool, like the data bars, what we can do is right-click and say Add Gallery to Quick Access Toolbar.
So right-click on whatever you like and it adds it to the toolbar.
And so now, I can add data bars with a single click instead of having to go hunt for it.
Now, the better way to go, though, is to use the Office button and go into Excel Options, choose Customize, and now we can find Commands.
I always like to go into Commands not in the ribbon-- those are things that you'll never find in the ribbon-- and basically I just find it here in the list, it's alphabetical.
Isosceles triangle, add, and we've now added that icon to the ribbon.
And something brand-new in Excel 2007 is we can now add icons to a specific workbook.
So I only want, in Book 1, I want to have the inside borders and the horizontal borders only to appear when this workbook's open.
So now, those two icons only show up when this workbook's open; other workbooks will just have the core set of icons here.
So you can add, you know, about 50 favorite icons going across there.
Several advantages.
One advantage is, you know, normally we're jumping back and forth from Home to Data, Home to Data, and you can only see half the icons at one time from those toolbars-- take the icons use all the time and just add them to your toolbar.
So, that way, you can very quickly access those.
Now, you'll notice that the workbook specific icons always appear at the end of the list.
So as you add more icons to the general Quick Access Toolbar, they will always appear before the workbook-specific icon.
So, great question from Robert: How do we customize that Quick Access Toolbar?
A couple of things: First of all, you need to right-click to get it down below the ribbon; and then right-click any icon to add it to the QAT.
Well, hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
[ music ]
