Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I close all excel spreadsheets at one time?
Excel 2007. Clicking the uppermost 'X' used to close down all active
spreadsheets, asking if you wanted to save all or step through each closing spreadsheets and ask specifically to save each one. That no longer appears to happen in 2007. Now the uppermost 'X' just closes the active spreadsheet. In effect, there is no difference between clicking the uppermost 'X' and clicking the specific spreadhseet's 'X'. Is there an option I am missing somewhere? It is incredably annoying no having that master 'shut down' button. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I close all excel spreadsheets at one time?
I got the same observation when I read your question. You can double-click
the Office Button on the upper-left side of the screen to close all worksheets. -- Chester C. Coronel Junior BSIT Student University of Asia and the Pacific, Philippines Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel "Jim T." wrote: Excel 2007. Clicking the uppermost 'X' used to close down all active spreadsheets, asking if you wanted to save all or step through each closing spreadsheets and ask specifically to save each one. That no longer appears to happen in 2007. Now the uppermost 'X' just closes the active spreadsheet. In effect, there is no difference between clicking the uppermost 'X' and clicking the specific spreadhseet's 'X'. Is there an option I am missing somewhere? It is incredably annoying no having that master 'shut down' button. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I close all excel spreadsheets at one time?
Jim,
I don't know specifically about Excel 2007, but holding Shift as you click File gives a "Close all" item. It doesn't close Excel, though. Try that in 07. And try using Alt-F4. Ya' never know. -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Jim T." <Jim wrote in message ... Excel 2007. Clicking the uppermost 'X' used to close down all active spreadsheets, asking if you wanted to save all or step through each closing spreadsheets and ask specifically to save each one. That no longer appears to happen in 2007. Now the uppermost 'X' just closes the active spreadsheet. In effect, there is no difference between clicking the uppermost 'X' and clicking the specific spreadhseet's 'X'. Is there an option I am missing somewhere? It is incredably annoying no having that master 'shut down' button. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I close multiple Excel '07 workbooks at the same time? | Excel Discussion (Misc queries) | |||
Book1 requires me to choose save each time i close excel | Excel Discussion (Misc queries) | |||
Open multiple spreadsheets, but close only one | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |