Undo and redo Actions for Excel

In Excel 2000, you also provide a multi-step undo that enables you to "undo" the most recent or multi-step action and revert to the state of the system before performing the operation. This function is a very useful tool for the occurrence of misoperation, so that we can remedy it in time.

There are two ways to undo an action. One is to press the Undo button on the toolbar. The second is to go to the Edit menu and perform the Undo command. For example, to reset the size of all characters for a worksheet, such as the original character "8" point, the new set to "10" point, when the change is not satisfied with the new format, you can perform the Undo command back to the original settings. As with repetitive commands, some commands cannot be undone.

If you want to undo a multi-step action, click the Drop-down button next to the Undo button, as shown in Figure 5-2. Select the steps from which you want to repeat. You can undo up to 16 steps in Excel 97.

In addition, there is a repeat button on the toolbar that you can click with the mouse to achieve the purpose of the repeat operation. When we press the [F4] key to repeat some of the commands, the screen appears with the Repeating Command dialog box, and sometimes does not appear in the Repeated Command dialog box, and repeat the command again. If you want to repeat a multi-step operation, you can click the Drop-down button next to the repeating button, as shown in Figure 5-3. Select the steps from which you want to repeat.