will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Close All Excel Files
Posted on May 20th, 2008 by Debra Dalgleish
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)
- On the keyboard, press the Shift key.
- In Excel, click on the File menu
- 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
Comment from Debra Dalgleish
Time: June 30, 2008, 12:36 pm
Holding the Shift key also changes some of the buttons on the toolbar.