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 says goodbye.
Intentional 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 a tedious task. Save yourself the hassle by adding “Close All” to the Quick Access Toolbar:
Open the relevant settings:
For Windows: Select File → Options → Quick Access Toolbar.
In the “Choose commands from” dropdown, select “Commands Not in the Ribbon.”
Scroll down and select “Close All.”
Click “Add.”
Click “OK.” Now, “Close All” is conveniently located on the Quick Access Toolbar, allowing you to clear everything with a single click.
https://xrust.ru/news/311186-excel-dlja-chajnikov-zakroj-vse-rabochie-knigi-odnovremenno.html
