Microsoft Office Tutorials and References
In Depth Information
Much Ado about Undo
✓ Open in Browser: This command opens workbook files you save as web
pages (which I describe in Chapter 12) in your favorite web browser.
This command isn’t available unless the program identifies that the
selected file or files were saved as web pages rather than plain old Excel
✓ Open in Protected View: This command opens the workbook file in
Protected View mode that keeps you from making any changes to the
contents of its worksheets until you click the Enable Editing button that
appears in the orange Protected View panel at the top of the screen.
✓ Open and Repair: This command attempts to repair corrupted
workbook files before opening them in Excel. When you select this command,
a dialog box appears giving you a choice between attempting to repair
the corrupted file or opening the recovered version, extracting data
from the corrupted file, and placing it in a new workbook (which you
can save with the Save command). Click the Repair button to attempt
to recover and open the file. Click the Extract Data button if you tried
unsuccessfully to have Excel repair the file.
Much Ado about Undo
Before you start tearing into the workbook that you just opened, get to know
the Undo feature, including how it can put right many of the things that
you could inadvertently mess up. The Undo command button on the Quick
Access toolbar is a regular chameleon button. When you delete the cell
selection by pressing the Delete key, the Undo button’s ScreenTip reads Undo
Clear (Ctrl+Z). If you move some entries to a new part of the worksheet by
dragging it, the Undo command button ScreenTip changes to Undo Drag and
In addition to clicking the Undo command button (in whatever guise it
appears), you can also choose this command by pressing Ctrl+Z (perhaps
for unZap ).
The Undo command button on the Quick Access toolbar changes in response
to whatever action you just took; that is, it changes after each action. If you
forget to strike when the iron is hot, so to speak, and don’t use the Undo
feature to restore the worksheet to its previous state before you choose another
command, you then need to consult the drop-down menu on the Undo button.
Click its drop-down button that appears to the right of the Undo icon (the
curved arrow pointing to the left). After the Undo drop-down menu appears,
click the action on this menu that you want undone. Excel will then undo
this action and all actions that precede it in the list (which are selected