Quickly Close All Excel Files
October 11, 2016
Quickly close all files, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.
If you're using Excel 2010 or earlier, you can press Alt+F4 to close all the open Excel files. Unfortunately, in Excel 2013 and later, that handy trick doesn't work anymore, because of the multiple windows.
A while ago, I showed how to add the Close All button to the Quick Access Toolbar, as a way to replace that missing shortcut. 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.
It works! And as he mentioned, there is also a "Save All" button in the Close All message. Thanks Rostyslav!
If you'd like to learn more about pivot tables, John Michaloudis is hosting his last free Pivot Table Webinar tomorrow, Wednesday, October 12th, at 12 noon Eastern time. Learn how to set up a pivot table quickly, create an interactive dashboard with Slicers and pivot charts, and much more, in this one-hour session.
Here's a link to the registration page: Free Pivot Table Webinar
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.
Here are a couple of Excel articles I read recently, that you might find useful.
Make a Map - Mike Alexander shows how to create a map, using a pivot table and conditional formatting. As he says, it's not strictly accurate, but looks pretty cool. And it's a much easier technique than most others that I've seen. (Level - Intermediate)
Mouse Shortcuts - On the My Excel Online blog, learn 10 mouse double-click shortcuts. I use all of them except trick #8 -- that's new to me! (Level - All)
Also, see all my Excel products on my Contextures website.
In less than a week, 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 a 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.
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:53 AM