Add the Page Setup dialog launcher to your Excel 2007 Quick Access Toolbar. Episode 1003 shows you how.
This video is the 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 video is the 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:
Where's the Wednesday that I can't?
Used to be right there.
Hey, all right! It's another where is it Wednesday?
Thanks to George wood for the great, Where is it Wednesday theme.
Actually, this is kind of one that I discovered when I was doing a seminar last week in Springfield, Missouri.
I was talking about the Ribbon and you know how most of the good stuff is on the Home tab of the Ribbon.
and I was kind of a you know complaining a little bit about the Page Layout tab.
You know why isn't Print Preview here and be really nice to have Print Preview and so, let's do two tips today.
First tip is if you find a command that's buried somewhere, so Print, Print Preview and you believe that command is worthy of being on the Ribbon.
You can right click it and say Add to Quick Access Toolbar and then you don't have to go into the menu formerly known as File, Print, Print Preview all the time You know have one click access to Print Preview right there.
Now, and you know one caution here is that there are many commands that for some reason they seem to have run out of icons and they use the green crystal ball.
So, if you add a lot of things to the quick access toolbar, well you know you're gonna end up with a whole bunch of crystal balls And you have to hover all at the time to try and figure out.
What the heck that crystal ball means and so I was going along in the seminar and talking about the whole set Page Layout tab here and in general.
The only thing I really need here is page setup and I don't like the way that they have the new page setup and that my favorite icon on this entire thing is the dialog launcher, this dialog launcher right here which will take me into the old Page Setup dialog. I'm sorry. I just like the old Page Setup.
I understand exactly how it worked. I really know how to use it very well.
I can fly through here and do all the settings that I need to do.
I said wouldn't it be nice if we could right click that little dialog launcher, and get that to appear on the quick access toolbar and just for the heck of it I tried it and sure enough the dialog launcher you can add to the quick access toolbar and it's called the Page Setup.
So, now you don't have to come back to Page Layout you can just click Page Setup and get back to the old Excel 2003 page setup dialog turns out you know that there's many dialogue launchers here this will get us in the format cells and so on.
So, you know you can add those dialogue launchers to the quick access toolbar and a faster way to get to a lot of those things.
Now, just as a caution, my quick access toolbar shown below the Ribbon.
If you haven't adjusted your quick access toolbar, It's going to start out above the Ribbon starts out up here.
So, I always like to move it down closer the spreadsheet I'll right click and say show below the Ribbon and a good way to go so for those are using excel 2007, a couple of cool tricks to get your favorite commands on the quick access toolbar and the commands taking us back to the old excel 2003 dialog box.
Hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Worse if Wednesday That I can't He used to be right there. I choose you
Used to be right there.
Hey, all right! It's another where is it Wednesday?
Thanks to George wood for the great, Where is it Wednesday theme.
Actually, this is kind of one that I discovered when I was doing a seminar last week in Springfield, Missouri.
I was talking about the Ribbon and you know how most of the good stuff is on the Home tab of the Ribbon.
and I was kind of a you know complaining a little bit about the Page Layout tab.
You know why isn't Print Preview here and be really nice to have Print Preview and so, let's do two tips today.
First tip is if you find a command that's buried somewhere, so Print, Print Preview and you believe that command is worthy of being on the Ribbon.
You can right click it and say Add to Quick Access Toolbar and then you don't have to go into the menu formerly known as File, Print, Print Preview all the time You know have one click access to Print Preview right there.
Now, and you know one caution here is that there are many commands that for some reason they seem to have run out of icons and they use the green crystal ball.
So, if you add a lot of things to the quick access toolbar, well you know you're gonna end up with a whole bunch of crystal balls And you have to hover all at the time to try and figure out.
What the heck that crystal ball means and so I was going along in the seminar and talking about the whole set Page Layout tab here and in general.
The only thing I really need here is page setup and I don't like the way that they have the new page setup and that my favorite icon on this entire thing is the dialog launcher, this dialog launcher right here which will take me into the old Page Setup dialog. I'm sorry. I just like the old Page Setup.
I understand exactly how it worked. I really know how to use it very well.
I can fly through here and do all the settings that I need to do.
I said wouldn't it be nice if we could right click that little dialog launcher, and get that to appear on the quick access toolbar and just for the heck of it I tried it and sure enough the dialog launcher you can add to the quick access toolbar and it's called the Page Setup.
So, now you don't have to come back to Page Layout you can just click Page Setup and get back to the old Excel 2003 page setup dialog turns out you know that there's many dialogue launchers here this will get us in the format cells and so on.
So, you know you can add those dialogue launchers to the quick access toolbar and a faster way to get to a lot of those things.
Now, just as a caution, my quick access toolbar shown below the Ribbon.
If you haven't adjusted your quick access toolbar, It's going to start out above the Ribbon starts out up here.
So, I always like to move it down closer the spreadsheet I'll right click and say show below the Ribbon and a good way to go so for those are using excel 2007, a couple of cool tricks to get your favorite commands on the quick access toolbar and the commands taking us back to the old excel 2003 dialog box.
Hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Worse if Wednesday That I can't He used to be right there. I choose you
