Excel - Bring Back the Legacy Dialog Boxes - Episode 1211.105
3,829 views · Published 17 July 2010 · 1:45 · Indexed 16 November 2026
Channel: MrExcel.com · 2010 · Education
Microsoft Excel Tutorial: Bring Back the Full Dialog Boxes using Dialog Launchers. Welcome back to the MrExcel netcast! In this chapter, we're diving into the world of legacy dialog boxes in Excel 2010. I'm Bill Jelen, and I'm excited to show you how to use these dialog boxes to enhance your Excel experience. As you may know, the ribbon in Excel 2010 is organized into tabs and groups. Within these groups, you'll find various commands and options. However, if you're like me and prefer the old way of doing things, you can easily access the legacy dialog boxes by clicking on the tiny symbol in the lower right-hand corner of many of the groups. This symbol looks like the top left corner of a piece of paper with an arrow pointing down into the right. By clicking on this symbol, Excel will take you back to the familiar Excel 2003 dialog box. This is especially useful if you're familiar with how to set up certain features in Excel 2003 and don't want to spend time trying to figure out how to do it on the ribbon. It's a quick and easy way to get back to the old way of doing things. One of my favorite uses for the legacy dialog boxes is on the Page Layout tab. If I need to make changes to my page setup, I simply click on the Dialog Launcher and have full control over the four tabs that we always had in Excel 2003. This allows me to easily set up things like rows to repeat at the top, header/footer, and margins. It's a great tool to have at your disposal in Excel 2010. Thanks for tuning in to this netcast from MrExcel. I hope you found this chapter on legacy dialog boxes helpful. Be sure to check back for more Excel tips and tricks in our future netcasts. And don't forget to check out our sponsor, MrExcel.com, for even more Excel resources. 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/ Table of Contents: (00:00) Legacy Dialog Boxes (00:12) Explanation of "The Dialog Launcher" (00:22) Microsoft's term vs. MrExcel's term (00:40) Symbol in lower right-hand corner of many groups (01:02) Quick access to familiar settings (01:12) Changing Page Setup (01:22) Full control of four tabs (01:35) 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 Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152890/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920