Open & Save files faster in Excel 2013 [quick tip]

Posted on November 18th, 2014 in Learn Excel - 22 comments

Excel 2013, the newest version of Excel as of writing this has many great features like data modeling, improved pivot tables, power view, flash fill etc. But one thing that I find very annoying is the Open & Save experience. Any time we open a file or save a workbook (which happens a lot everyday), we must navigate the painful backstage screen to select our favorite folders. You see, Excel 2013 supports cloud saving. So that means, by default it will show your Office 365 or OneDrive or SkyDrive or whatever fancy new name Microsoft has for these things. But I am not so much in to clouding. Heck, I see a passing cloud in the sky and I almost run into my house. So what to do?

Simple. We can turn off these features.

We can save & open files faster by using below trick (I am cursing myself for not learning this earlier).

Open and save files faster in Excel 2013 with this trick

  1. Go to Excel options (this will be visible only once you open any file, even a new one) from File menu.
  2. Click on Save
  3. Enable “Dont show backstage when opening or saving files”
  4. Enable “Save to computer by default”
  5. Optional: Add a default save location for your workbooks
  6. You are done.

Now that I have turned on these features, I no longer pay the extra click tax to Microsoft whenever I save my files.

What about you?

More on working with Excel faster

 

Written by Chandoo
Tags: , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

22 Responses to “Open & Save files faster in Excel 2013 [quick tip]”

  1. Jim says:

    I recently disabled all unnecessary animations (when possible). That's pepped things up a bit.
    https://www.ablebits.com/office-addins-blog/2013/07/11/disable-animation-excel-2013/

  2. BFG 9000 says:

    Thank you!

    I had Office 365 forced upon me a little while ago & this has been my biggest annoyance so far.

  3. Ducheznee says:

    Lovely! I grumbled every time I saw that Save window. Gonna poke around the Options and see what else can be fixed.

  4. dianne says:

    Love it Here's a good companion shortcut! F12 goes straight to Save As!

  5. Jeff Weir says:

    'Extra Click Tax'. I like. That's going in the book...

  6. Jeff Weir says:

    Chandoo - I'm an F12 guy, so I never see backstage when saving. The only time I'd want to do the above is if I could set that 'Default File Location' to the Recent Places list, so I could instantly choose one option directly from the list that populates, rather than having to click on the 'Recent Places' icon first.

  7. orkun says:

    thanks dude.
    I love your way of approaching the problems... đŸ™‚

  8. anne says:

    Chandoo, different question this time: how do you do the screen copy with the raffled edging?
    Thanks so much

  9. denice says:

    What a straight forward option. Shows you that when we go into the Options in excel we never look closely. Thank you Chandoo for solving this problem. I will now also stop paying the double click tax to Microsoft.

    I am also interested in the answer to Anne's question.

  10. Cormac says:

    You can also add file New, Open, Save and Save As to your Quick Access Toolbar. I have all my old favourites on my Quick Access Toolbar

  11. Jake says:

    Awesome thank you!

  12. Christiane says:

    I have been using 2013 for more than a year now and thought this was just not possible to avoid. Just made the change, it will be SOOOO much quicker now thank you !!!

  13. Reema says:

    Hi thanks for the excellent post. however the link to "Learn a few shortcuts, you will become superhero at work" is not working. it says "Sorry, but I cant find the page you are looking for."
    Please do look into it.

  14. Kiev says:

    Nice tip, I really love it. Thanks Chandoo.

  15. Sachin says:

    Oh my God, by chance I came to this post and this resolves my biggest annoyance so far as we were forced to Office 2013 in office. Thank you so much!

  16. John Gamiles says:

    Has anyone encountered checking the "Don't show the Backstage when opening or saving files" and Excel 2013 still shows the Backstage screen? Microsoft acknowledges the issue but isn't calling it a bug they plan to fix.

  17. […] Chandoo shares a quick tip for opening and saving files faster in Excel 2013. […]

  18. rahgav says:

    thank you for the great tips i would like to get more information on new tips my mail id is rahgav@q8living.com

  19. […] presentaremos un sencillo truco tomada del sitio web Chandoo.org, el cual en su artĂ­culo Open & Save files faster in Excel 2013 [quick tip] (Abrir y guardar archivos de forma rĂ¡pida en Excel 2013 [Truco rĂ¡pido]) nos muestra una rutina de […]

Leave a Reply