Immediately shut your whole Excel info

First, I’ve received two brief bulletins, after which there’s a effortless Excel trick for you. Are you ready for Spreadsheet Day 2016? quick, shut your whole Excel info, and bake a cake!

Spreadsheet Day 2016

On Monday October 17th, it should be Spreadsheet Day. i'm hoping you’re making big plans for this important annual adventure! seeing that it’s on a Monday this 12 months, perhaps that you could turn it into a protracted weekend.

final 12 months, Albert Kroes had this attractive spreadsheet cake made for his branch at work, in honour of the occasion. The date on the cake, October 17, 1979, is when VisiCalc turned into first launched, and that’s why we celebrate on Oct. seventeenth every yr.

How will you be celebrating Spreadsheet Day 2016?

Product update

There became a minor update to my information Entry Popup list package (edition 6.05). It now works accurately when you've got a based drop down record, with just one item within the listing. The handiest exchange is in the code for the frmDVList, so that you can exchange that on your tasks, in case you’ve run into that issue.

To down load the new edition, use the hyperlink within the e mail that you simply got in case you purchased the product. if you can’t find that email, or have used up your 5 downloads, let me recognize, and that i’ll send you a brand new hyperlink.

shut all of your Excel info

In Excel 2010 and previous, you could press Alt+F4 to close your whole Excel data. 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 confirmed how to add the shut All button to the short entry Toolbar, as a method to change that lacking shortcut. It takes a minute to install, however after that, it’s an easy strategy to close all your Excel file.

And now there’s an excellent more convenient solution. final week, Rostyslav made a touch upon that article, describing a shortcut that he uses — press the Shift key, and click the X at the precise appropriate of 1 of the Excel home windows.

I’m doubtless the closing grownup to know about it, however i was very chuffed to study that shortcut to shut all your Excel info!

And as Rostyslav mentioned in his comment, there is additionally a “save All” button in the close All message. Thanks Rostyslav!

________________________