Microsoft Office Tutorials and References
In Depth Information
Finding the Missing No to All Button When Closing Files
Finding the Missing No to All Button
When Closing Files
Assume that you have a dozen or so workbooks open, and you want to close Excel without
saving any changes. Excel displays the dialog box shown in Figure 180-1. And it does it for every
changed workbook that is open.
Figure 180-1: Excel displays this prompt for every unsaved file.
As you can see, this dialog box has a Save All button but lacks a No to All button. Here’s the
secret: Press Shift while you click the Don’t Save button. That action functions exactly like
clicking a No to All button — if one existed.
By the way, this tip works in many of the Windows dialog boxes as well. For example, if you’re
copying a group of files and some of the files already exist, Windows makes you verify your
overwrite intentions. That dialog box also lacks a No to All button, but you can Shift+click the