Working with Spreadsheet Files
If you have more than one workbook file open, you can close them all with one command. Just hold down the Shift key while you pull down the File menu from the menu bar. The Close command on the File menu becomes Close All. Select Close All to close all open workbook files. Excel will prompt you to save changes in any open workbooks, if necessary.