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

Watch on YouTube

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