**Excel for Dummies – Close All Workbooks at Once**
The “Close” button in the upper-right corner of Excel for Windows makes it easy to close workbooks, whether you intended to or not. Close the last open workbook, and Excel will say goodbye.
Deliberate but repetitive methods of “clearing the deck” one workbook at a time include pressing Ctrl+F4 or Ctrl+W or selecting File→Close, writes https://xrust.ru/.
In any case, closing multiple workbooks one by one is tedious work. Eliminate the hassle by adding “Close All” to the Quick Access Toolbar:
Follow these steps to configure it:
For Windows: Select File→Options→Quick Access Toolbar.
In the “Choose commands from” list, select “Commands Not in the Ribbon.”
Scroll down and select “Close All.”
Click “Add.”
Click “OK.” Now, “Close All” is conveniently located in the Quick Access Toolbar, allowing you to clear everything with just one click.
https://xrust.ru/news/311186-excel-dlja-chajnikov-zakroj-vse-rabochie-knigi-odnovremenno.html
