Look Who it Was Random video

Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920

338 views · Published 2 January 2009 · 2:20 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Display all Excel Options using the full Excel-2003-style dialogs.

Welcome back to the MrExcel netcast! I'm Bill Jelen and I want to wish everyone a Happy New Year. It's January 2nd and I'm sure some of you have received new computers for Christmas or maybe it's a new budget year and you finally have the funds to upgrade to Excel 2007. But now you're faced with the challenge of navigating through the new interface and trying to find the features you're used to in Excel 2003. Don't worry, I've got you covered with some helpful tips in this episode.

As you may have noticed, the most important features are now located on the Home tab. But if you're looking for something that used to be on the File menu, like Print or Save, you can find it under the Menu formerly known as File - the big round circle in the top left corner. But here's a quick tip to make your transition to Excel 2007 a little smoother. Within each Ribbon tab, there are groups of related features. And in the lower right-hand corner of these groups, you'll find a tiny symbol called a Dialog Launcher. This is Microsoft's fancy term for what I like to call the "Please just take me back to the way I know and love" button.

So if you're trying to find a feature like File, Page Setup, you can simply click the Dialog Launcher in the Page Setup group and it will take you back to the familiar Excel 2003 dialog box. This also works for other features like Format Cells - just click the Dialog Launcher in any group on the Home tab and it will take you to the old Format Cells dialog box. It's a great way to quickly find your way around the new interface and get back to the old dialogue. So don't stress about learning the new location of every feature, just look for those Dialogue Launchers and you'll be good to go.

Thanks for tuning in to this netcast from MrExcel. I hope these tips will make your transition to Excel 2007 a little easier. Don't forget to subscribe to our channel for more Excel hacks and tips. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/



Quick tips for someone upgrading from Excel 2003 to Excel 2007. 
Dealing with the new Ribbon in Microsoft Office. 

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! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Theme music
(0:14) Happy New Year
(0:30) Tips When Upgrading to Excel 2007
(0:50) The Office Logo is the File Menu
(1:03) Dialog Launcher for Full Dialog box in Excel
(1:58) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Excel 2007 Ribbon tabs and groups
Excel 2007 settings location
Excel 2007 tips and tricks
Excel 2007 tutorial
Finding features in Excel 2007
Finding File, Page Setup in Excel 2007
Finding Format Cells in Excel 2007
MrExcel netcast transcript
Navigating Excel 2007 quickly
Transitioning to Excel 2007
Using the Dialog Launcher in Excel 2007
Using the old dialog box in Excel 2007


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1151960/

More from this channel