Learn Excel - Explorer-Type Save As and Open in Excel 2013 - Podcast 1854

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Feb 4, 2014.
Back in Excel 2010, doing Save As or Open would immediately take you to a Windows-Explorer-style dialog box. In Excel 2013, you have to wade through extra clicks where you have to choose to save to your computer instead of SkyDrive/OneDrive, then click Browse. In this episode of the MrExcel podcast, a setting buried in Excel 2013 options to get you directly to the old Explorer dialog.
maxresdefault.jpg


Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast . Episode # 1854 Excel 2013 Bringing back the Explorer - Type Dialogs Hey welcome back to the MrExcel netcast. I'm Bill Jelen.
What if you were a fan of Excel 2010 and used "Save As" or "Open" so Ctrl + S to "Save As" for this unsaved workbook.
We get the old explorer, windows explorer type dialog box. The same thing with Ctrl + O would bring us to those dialog boxes.
But in excel 2013, if we do any of those Ctrl + O it comes to the backstage view.
Same thing with Ctrl + S Here, you know first use the Computer then click Browse, and then we finally get to the dialog box.
A couple of extra clicks.
But those extra clicks will add up.
You know if you have to do it dozens of times a day, so let's go into "File" "Options" and back to the "Save" tab. Right first one is "Save to Computer by default".
Click OK.
Now when we do Ctrl + S, you see that the computer is already checked, all right.
So that saves us one extra click.
But I still want to get to the old old Dialog box, so we'll be back in "Options". Alt + F +T Go to the same dialog box and right here, "Don't show the Backstage when opening or saving files" Click OK. All right now.
We do Ctrl + S which should bring up "Save As" and Bam! directly to the old dialog box.
Ctrl + O for open directly to the old dialog box.
Now that works great if you happen to be Ctrl + S or Ctrl + O your favorite ways to go.
If you still do Alt + F + A for Save As or Alt + F + O for File Open, those are going to take you back to the new way.
So Alt + F + A.
It's going to bring you to "Save As" because Alt + F is opening the backstage view.
So my problem I use Alt + F + A and Alt + F + O.
I'm go have to retrain myself to do Ctrl + S and Ctrl + O.
But hey simple enough. Also hate the "Save As" but the Quick Access toolbar that gets you back to the old style dialog box.
No matter what, no matter what your setting is in File Options.
So consider using that one.
Hey I want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top