Leading the way in Microsoft Office Development

Step 1 - Using Undo and Redo

This feature is extremely useful and is not workbook or worksheet specific.

The Undo and Redo buttons on the standard toolbar allow you to quickly correct mistakes without repeating the steps again.

Both these buttons include drop-down lists to allow you to perform multiple undos and redos.

It is possible to undo and redo up to the last 16 consecutive actions.

Every time you use the Undo feature, those actions that you undo are placed in the Redo category.

After a workbook has been saved it is not possible to undo any actions performed in that workbook.

Step 2 - Using Undo

Whenever you make mistakes you can quickly undo a single action by selecting (Edit > Undo).

This can only be used to undo single actions at a time.

You can repeat the undo by using the shortcut key (Ctrl + Z).

You can also use the Undo button on the standard toolbar.

The black arrow on its right gives you access to the actions that were last undertaken.

You can quickly undo multiple action by dragging the mouse over the list and selecting which actions you want to undo.

Step 3 - Using Redo

You can either use the (Edit > Redo) to redo single actions or use the Redo button on the standard toolbar.

The Redo is structured exactly the same as the Undo except that a Redo action cancels the Undo action.

When you undo a number of actions, these actions are transferred to the Redo list.

If you then redo these actions they are transferred back to the Undo list.

Step 4 - Using Repeat

It is possible to repeat your last action (assuming that it was not an Undo).

You can also repeat your last action by using the shortcut key (F4) or (Ctrl + Y).

Step 5 - Things you cannot Undo

Some action especially those involving worksheet manipulation cannot be undone (such as inserting or deleting of worksheets).

Any actions that you cannot undo will not appear on the drop-down list.

You also cannot undo settings from the (Tools > Options) dialog box, saving or printing.

Step 6 - Things to Remember

The (Edit > Undo) command is workbook (not worksheet) specific.

It is possible to change the registry entry if you want to be able to undo more than 16 actions.