
Apr 04, 2017
If you find that you sometimes have more than one Excel spreadsheet open at a time and need a quick way to close and save all of them at once… Close All is for you!
Close All is not in the Ribbon or the Backstage View (when you click File) so needs to be added to the Quick Access Toolbar (the little toolbar at the top-left of the Excel screen). To add Close All to the QAT, follow these simple steps:
1. Right click the ribbon and choose Customize the Quick Access Toolbar
2. From the Choose Commands From menu choose Commands Not in the Ribbon
3. Scroll down and find Close All in the list of commands and then click the Add button
4. Click OK.
You are now able to click Close All to close and save multiple files at once!
To get a solid understanding of Excel – both advanced and beginner, check out our Excel courses.
How do your Excel skills stack up?
Test NowNext up:
- Creating Logos with Illustrator CC
- Reuse and Share InDesign Presets
- Setting up an Azure AD Connect Staging Mode
- The Windows 10 Calculator – A Quick Squiz
- Get Creative with Adobe Stock Templates!
- ITIL® is Is Not a Four Letter Word
- The Benefits of Office 365
- ITIL® Practitioner – Looking at the nine guiding principles
- ITIL® Practitioner Guidelines – Start Where You Are
- Get Microsoft Certified
Previously
- Creating Logos with Illustrator CC
- Reuse and Share InDesign Presets
- Beyond resilience
- How-to: Use clipping masks for typography
- Is it really that hard to edit a Hosts file?
- RESILIA™ Hotspot
- How REAL is your reality?
- Nintex: Read data back into a new Repeating Section control
- Master Document in Word – Part 3
- A good presentation is not about you