Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Excel 2007 » "close all" feature

"close all" feature

Previous | Next
Latest post Mon, Mar 3 2008 7:34 AM by Anonymous. 2 replies.

  • Fri, Feb 29 2008 7:15 AM

    "close all" feature

    Reply |Contact

    I used to use this (Shift+File menu option) to obtain Close all to (surprise, surprise) close all open files without quitting Excel in versions pre 2007.  Is there any way of still doing this that I have not found?
    • Post Points: 21

  • Fri, Feb 29 2008 11:02 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: "close all" feature

    Reply |Contact |Mark as Answer

    Angela

     

    Add the close all button to your QAT (Quick Access Toolbar). Go to Office Button>Excel Options>Customize>Chnage Popular Commands to All Commands, scroll down the list and select Close All and click Add.

    It will now reside on the little toolbar above (or if you've chnaged it below) the ribbon

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    Filed under: ,
    • Post Points: 21

  • Mon, Mar 3 2008 7:34 AM In reply to

    Re: "close all" feature

    Reply |Contact |Mark as Answer

    And It will have the same button image as the close button.....thats improvement for you...

    Sam

     
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.