Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Closing One Sheet at a Time?
I have Excel 2007 and tend to open multiple sheets at a time. In
Excel 2003, when you elect to close the program, it would close all opened sheet, except those with changes (it asks if you want to save). In Excel 2007, it requires you to close each opened sheet manually. Is there a way to get Excel 2007 to close all sheets when one elects to close the program - I hate these extra steps! I looked thru the Options, but did not see a entry for what I want. Does anyone have any advice/suggestions? Thanks Charliec ************************************************** **** Charliec |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Closing One Sheet at a Time?
Hi, Are you talking about sheets or workbooks??
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Closing One Sheet at a Time?
Hi Charliec
In Excel 2007 you can double click on the Office Buttton (round button next to the Home tab) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Charliec" wrote in message ... I have Excel 2007 and tend to open multiple sheets at a time. In Excel 2003, when you elect to close the program, it would close all opened sheet, except those with changes (it asks if you want to save). In Excel 2007, it requires you to close each opened sheet manually. Is there a way to get Excel 2007 to close all sheets when one elects to close the program - I hate these extra steps! I looked thru the Options, but did not see a entry for what I want. Does anyone have any advice/suggestions? Thanks Charliec ************************************************** **** Charliec |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Closing One Sheet at a Time?
On Sat, 20 Oct 2007 02:12:02 -0000, "D." wrote:
Hi, Are you talking about sheets or workbooks?? I guess that would be workbooks. ************************************************** **** Charliec |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Closing One Sheet at a Time?
You can set your view settings so that all Excel windows are not shown in
the taskbar. I don't know exactly where this is, click on the round Office button, click Excel Options, and check out the various view options. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charliec" wrote in message ... I have Excel 2007 and tend to open multiple sheets at a time. In Excel 2003, when you elect to close the program, it would close all opened sheet, except those with changes (it asks if you want to save). In Excel 2007, it requires you to close each opened sheet manually. Is there a way to get Excel 2007 to close all sheets when one elects to close the program - I hate these extra steps! I looked thru the Options, but did not see a entry for what I want. Does anyone have any advice/suggestions? Thanks Charliec ************************************************** **** Charliec |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2003/2007 Crash when opening/closing files | Excel Discussion (Misc queries) | |||
CLosing Excel 2007 with personal macro workbook | Excel Discussion (Misc queries) | |||
Excel 2003 - long closing time when have many add-ins installed | Excel Discussion (Misc queries) | |||
how to let excel ask to save the sheet when closing the excel file | Setting up and Configuration of Excel |