Close All Excel Files

While working in Excel 2003 (or earlier versions), you might open several files, to compare them, or copy and paste from one to another. When you’re finished with those files, you can quickly close all of them, and leave Excel open. (Note: This tip also works in Word)

  1. On the keyboard, press the Shift key.
  2. In Excel, click on the File menu
  3. Click on the Close All command


In Excel 2007 you can add the Close All command to the Quick Access Toolbar. There are instructions for adding a command on the Microsoft web site, or look in Excel 2007’s Help:
  http://office.microsoft.com/en-gb/word/HA102223271033.aspx