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. 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!


More DIY videos at 5min.com

Video Transcription

Hey! Welcome back to the MrExcel Netcast I am Bill Jelen and I want to wish everyone a Happy New Year. We are back from the New Year holiday, January 2nd here. I am assuming so me of you got new computers for Christmas or maybe it is a new year, new budget year and have some money you are 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 are finding is that you are having the hunt from tab to tab to tab. Just trying to figure out where they hid the feature you are trying to look for. Remember most of the important stuff is on Home. I find this and spend a lot of myself between Home and Data. If you are looking for things that used to be on the File menu such as print or save that is under the menu formally known as file, this big round circle up here, has a lot of information. But a couple of tips to really help you as transition to Excel 2007; first tip, we have ribbon tabs, Home, Insert, Page Layout and then within the tabs there is groups. So here, this is the page setup group, the scale to fit group, the sheet options group and then many groups throughout the ribbon. In the lower right hand corner of the group is this tiny little symbol, this symbol is called a Dialogue Launcher. That is what Microsoft calls it. I have call it the please just take me back to the way I know in love. If you click that icon, what it is going to do is going to take you back to the Excel 2003 dialogue box. So if you are trying to find file page setup for example, and you can just come to the page setup group. Or if you are trying to find format cells, you can go to anything on the home tab and click the dialogue launcher and that is going to take you to into the good old format cells dialogue box, great way to find your way around very quickly just get back to the old dialogue. Now all of these settings are in the new place, of course, in Excel 2007, but if you are just in a hurry and want to find the old dialogue box, look for those dialogue launchers a great way to go. I want to thank you for stopping by I will see you next time for another Netcast from MrExcel.