Is there a comparison list of commands? (Excel 2003 vs 2007)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Upon creating or making changes to multiple Excel Work Sheets in 2007, and
then clicking "close", a pop up question appears asking if you want to "save"
the Work Sheet. In Excel 2003, the pop up question asks if you want to
"save" the displayed Work Sheet, or "Save All". Is there a way of "Saving
All" in Excel 2007?
 
I'm using 2007 and I sure see it. Of course, that only pops up when closing
Excel, not when closing ONLY the active sheet.

In earlier versions you could hold down the shift key and click on the File
menu to get the option to Close All - is that what you are thinking of?

dustyr said:
To Duke Carey:
To answer your question: Yes, "Yes to all" is the feature I'm looking for,
however, the 2007 version of Exel does not show it and I don't know where to
look.


Duke Carey said:
If I have unsaved changes in more than one file I am asked

"Do you want to save changes to " & [active workbook's name]

The buttons are Yes, Yes to All, No, and Cancel

Isn't *Yes to All* the feature you seek?

dustyr said:
Upon creating or making changes to multiple Excel Work Sheets in 2007, and
then clicking "close", a pop up question appears asking if you want to "save"
the Work Sheet. In Excel 2003, the pop up question asks if you want to
"save" the displayed Work Sheet, or "Save All". Is there a way of "Saving
All" in Excel 2007?
Click to expand...
Click to expand...
Click to expand...
 
Close All is listed under "Commands not in Ribbon", so I'm guessing
there is no other way.


You can modify the Quick Access Toolbar (QAT) and add the Close All command.
No idea how you can access it otherwise.



dustyr said:
To Duke Carey:
To answer your question: Yes, "Yes to all" is the feature I'm looking for,
however, the 2007 version of Exel does not show it and I don't know where to
look.
Click to expand...
If I have unsaved changes in more than one file I am asked
"Do you want to save changes to " & [active workbook's name]
The buttons are Yes, Yes to All, No, and Cancel
Isn't *Yes to All* the feature you seek?
:
Upon creating or making changes to multiple Excel Work Sheets in 2007, and
then clicking "close", a pop up question appears asking if you want to "save"
the Work Sheet. In Excel 2003, the pop up question asks if you want to
"save" the displayed Work Sheet, or "Save All". Is there a way of "Saving
All" in Excel 2007? - Hide quoted text -
Click to expand...
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top