"Close multiple or all files at once instead of just one at a time"
I often have multiple files open in Excel. I hate having to close each file separately. Is there an easier way?
Yes there is, just use:
ASAP Utilities » File & System » Close multiple files at once...
This utility makes it easier to close multiple files at once.
It shows you a list of all open workbooks and you can choose which ones to close.
When you start the utility then by default all files except for the active workbook are selected to be closed.
The utility is useful when you work with a lot of files that are opened in Excel and for example when you want to close all files, or all except for a few.
You can set the utility give you a warning before a file is closed from which the changes haven't been saved yet.
In such a case you can choose to save the file first before it is closed, not save the changes, or cancel the closing of it.
Bonus tips, also interesting
- ASAP Utilities » File & System » Close all open files without saving changes
- ASAP Utilities » File & System » Close all saved files
- ASAP Utilities » File & System » Close and delete current file
- ASAP Utilities » File & System » Reopen current file without saving changes
- ASAP Utilities » File & System » Save file as... and use the first cell as the suggested filename
How much time will it save?
It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on how much you use Excel, the number of files/workbooks that you are working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.
In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for home projects, schoolwork and use by charitable organizations) or the fully functional 90-day Business trial.