Learn Excel from MrExcel Episode 920 - 2003 Dialogs

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 2, 2009.
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!
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top