Excel - Explorer-Type Save As and Open in Excel 2013 - Episode 1854
1,813 views · Published 4 February 2014 · 2:28 · Indexed 25 October 2026
Channel: MrExcel.com · 2014 · Education
Microsoft Excel Tutorial: Back in Excel 2010, doing Save As or Open would immediately take you to a Windows-Explorer-style dialog box. In Excel today, you have to wade through extra clicks where you have to choose to save to your computer instead of OneDrive, then click Browse. In this episode of the MrExcel podcast, a setting buried in Excel Options to get you directly to the old Explorer dialog. Welcome to the MrExcel podcast. In this episode, we will be discussing a handy feature in Excel 2013 that brings back the familiar Explorer-type dialogs for saving and opening files. I'm Bill Jelen, and let's dive right in. If you were a fan of Excel 2010, you may have been used to using the "Save As" or "Open" commands with the familiar Windows Explorer-type dialog box. However, in Excel 2013, these commands now bring up the backstage view, adding a few extra clicks to the process. This may not seem like a big deal, but those extra clicks can add up if you have to do it multiple times a day. But fear not, there is a solution. By going into the "File" menu and then "Options," we can change the default setting for saving to the computer. This means that when we use the Ctrl + S shortcut, the computer option will already be selected, saving us one extra click. But what about getting back to the old dialog box? Well, we can also change a setting in the "Save" tab of the options menu to always show the old dialog box when saving or opening files. This means that even if we use the Alt + F + A or Alt + F + O shortcuts, we will still be taken to the familiar Explorer-type dialog box. Of course, if you prefer to use the Alt + F + A or Alt + F + O shortcuts, you can still do so, but they will take you to the backstage view. So if you're like me and have to retrain yourself to use the Ctrl + S and Ctrl + O shortcuts, don't worry, it's a small adjustment to make. And if you really miss the old "Save As" button, you can always add it to your Quick Access Toolbar for easy access. Thanks for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe and hit the notification bell to stay updated on all our latest episodes. See you next time for more Excel tips and tricks. 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) Explorer-Type Dialogs in Excel (00:11) Excel 2013 vs. Excel 2010 Dialog Boxes (00:23) How to Access Old Dialog Boxes in Excel 2013 (01:03) Customizing File Options for Quick Access (01:44) Retraining Shortcuts for Old Dialog Boxes (02:08) Using Quick Access Toolbar for Old Dialog Boxes (02:18) 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: Backstage view Ctrl + O Ctrl + S Excel 2013 Explorer-Type Dialogs File Options Quick Access toolbar Save As Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153679/
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