fbpx
Search
Close this search box.

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

Share

Facebook
Twitter
LinkedIn

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

 

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

23 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 […]

  20. Armen says:

    Thank you
    love excel

Leave a Reply