As you switch to Excel 2007 and try to find things on the new Ribbon, look for the tiny dialog launcher icons to take you back to the old Excel 2003 dialogs. Episode 920 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:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Want to wish everyone a Happy New Year.
We're back from the New Year holiday, January 2nd here.
I am assuming some of you got new computers for christmas, or maybe it's a New Year, New budget year, and there's some money, you're getting a new computer and now you have Excel 2007.
And what do we do with this?
Well, you know, obviously the thing that you're finding is that you're having to hunt from tab to tab to tab, to try and figure out where they hid the feature you're trying to look for.
Remember most of the important stuff is on Home.
I find I spend a lot, myself, between Home and Data.
If you're looking for things that used to be on the File menu, such as Print or Save, that's under the Menu formerly known as File-- this big round circle up here has all that information.
But a couple of tips to really help you as you transition to Excel 2007.
First tip, we have Ribbon tabs; Home, Insert, Page Layout; and then within the tabs, there's Groups.
So here, this is the Page Setup group; the Scale to Fit group; the Sheet Options group; and in many groups throughout the Ribbon, in the lower right-hand corner of the group is this tiny little symbol-- the symbol is called a Dialog Launcher.
That's what Microsoft calls it; I call it the "Please just take me back to the way I know and love".
If you click that icon, what it's going to do is, it's going to take you back to the Excel 2003 dialog box.
So if you're trying to find File, Page Setup, for example, you can just come to the Page Setup group; or if you're trying to find Format Cells, you can go to anything on the Home tab and click the Dialog Launcher and it's going to take you into the good old Format Cells dialog box.
Great way to find your way around very quickly; just get back to the old dialogue.
Now, all of these settings are in a new place, of course, in Excel 2007, but if you're just in a hurry and want to find the old dialog box, look for those Dialogue Launchers-- a great way to go.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Want to wish everyone a Happy New Year.
We're back from the New Year holiday, January 2nd here.
I am assuming some of you got new computers for christmas, or maybe it's a New Year, New budget year, and there's some money, you're getting a new computer and now you have Excel 2007.
And what do we do with this?
Well, you know, obviously the thing that you're finding is that you're having to hunt from tab to tab to tab, to try and figure out where they hid the feature you're trying to look for.
Remember most of the important stuff is on Home.
I find I spend a lot, myself, between Home and Data.
If you're looking for things that used to be on the File menu, such as Print or Save, that's under the Menu formerly known as File-- this big round circle up here has all that information.
But a couple of tips to really help you as you transition to Excel 2007.
First tip, we have Ribbon tabs; Home, Insert, Page Layout; and then within the tabs, there's Groups.
So here, this is the Page Setup group; the Scale to Fit group; the Sheet Options group; and in many groups throughout the Ribbon, in the lower right-hand corner of the group is this tiny little symbol-- the symbol is called a Dialog Launcher.
That's what Microsoft calls it; I call it the "Please just take me back to the way I know and love".
If you click that icon, what it's going to do is, it's going to take you back to the Excel 2003 dialog box.
So if you're trying to find File, Page Setup, for example, you can just come to the Page Setup group; or if you're trying to find Format Cells, you can go to anything on the Home tab and click the Dialog Launcher and it's going to take you into the good old Format Cells dialog box.
Great way to find your way around very quickly; just get back to the old dialogue.
Now, all of these settings are in a new place, of course, in Excel 2007, but if you're just in a hurry and want to find the old dialog box, look for those Dialogue Launchers-- a great way to go.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
