Excel 2000 in a Nutshell

Name

Edit → Undo

Synopsis

The Edit → Undo command undoes or reverses the changes you have made to the document during a session. In other words, when you select Edit → Undo or Ctrl+z the most recent change is undone first, followed by the change made prior to that, and so on. If you undo more commands than you intended, you can use Edit → Redo to redo a command.

The Undo option takes the name of the most recent action. For example, if the last thing you did was bold the text in a cell, the menu option is Undo Bold. If an action cannot be undone, the menu option says Can’t Undo and is grayed out. This is the case when you open a worksheet or if you save a worksheet. (Once you save the worksheet, all stored Undo actions are erased.)

You can also select the Undo icon on the toolbar. It performs the same action as Edit → Undo. If you need to undo several actions you can select the Down Arrow button next to the Undo icon and highlight the actions that you want to undo.

The Benefits of Using AutoSave

If you have the AutoSave option turned on (Tools → AutoSave) the Undo list is reset each time an autosave is performed. You may want to set the AutoSave option at five- to ten-minute intervals. The AutoSave option is an Add-in that comes along with Excel. It can be loaded by selecting the AutoSave Add-In on Tools → Add-Ins (refer to Chapter 8).