Quickly Close All Your Excel Files

First, I’ve got two quick announcements, and then there’s a handy Excel trick for you. Are you ready for Spreadsheet Day 2016? Quick, close all your Excel files, and bake a cake!

Spreadsheet Day 2016

You only have a few days to get ready – on Monday October 17th, it will be Spreadsheet Day. I hope you’re making big plans for this important annual event! Since it’s on a Monday this year, maybe you can turn it into a long weekend.

Last year, Albert Kroes had this beautiful spreadsheet cake made for his department at work, in honour of the occasion. The date on the cake, October 17, 1979, is when VisiCalc was first released, and that’s why we celebrate on Oct. 17th each year.

How will you be celebrating Spreadsheet Day 2016?

spreadsheetdaycake2015

Product Update

There was a minor update to my Data Entry Popup List kit (version 6.05). It now works correctly if you have a dependent drop down list, with only one item in the list. The only change is in the code for the frmDVList, so you can replace that in your projects, if you’ve run into that problem.

To download the new version, use the link in the email that you got when you bought the product. If you can’t find that email, or have used up your five downloads, let me know, and I’ll send you a new link.

Close All Your Excel Files

In Excel 2010 and earlier, you can press Alt+F4 to close all your Excel files. In Excel 2013 and later, there is a separate window for each Excel file, and that handy trick doesn’t work anymore.

In 2013, I showed how to add the Close All button to the Quick Access Toolbar, as a way to replace that missing shortcut. It takes a minute to set up, but after that, it’s an easy way to close all your Excel file.

And now there’s an even easier solution. Last week, Rostyslav made a comment on that article, describing a shortcut that he uses — press the Shift key, and click the X at the top right of one of the Excel windows.

 

Close All Your Excel Files http://blog.contextures.com/

I’m probably the last person to know about it, but I was very happy to learn about that shortcut to close all your Excel files!

And as Rostyslav mentioned in his comment, there is also a “Save All” button in the Close All message. Thanks Rostyslav!

closeallwindows04

________________________

 

Close All Your Excel Files http://blog.contextures.com/

Save

You may also like...

6 Responses

  1. Peter Buyze says:

    A useful trick. But, when you do shift+click & are given a saving choice, if you do not want to click “save all” you get that choice before it closes the next file & so on. Furthermore, at the end of the series of files closed, Excel is also closed.
    If you want to close the files but keep Excel open, then you can close the files easily with CTRL+W.

  2. Jam says:

    Nice tip. I remember that in Excel 2000 and before (if my memory is correct), that if you were pressing ALT or CTRL before and clicking the File menu, the Close/Save option was changing to Close/Save All. I was desapointed when this disappeared. Nice to see it back :D

  3. Ivan M. says:

    Excel 2007 returns the dialog for saving of all files after double cliking of Office Button (top left corner). Maybe other version do the same…

  4. Thomas says:

    Another one, just for the record, I have an old keyboard shortcut memorized which I am s still using: Alt+F(ile), (e)X(it). Gives you the “Save all” option, and also closes the application.

Leave a Reply to Ivan M. Cancel reply

Your email address will not be published. Required fields are marked *