Excel 2010: Undo, Redo, and redo specific actions

Undo and redo are common operations that we use in our daily documents and tables, which are generally easy to handle with ctrl+z, and you can undo and redo up to 100 operations in Microsoft Office Excel, even after you save the worksheet. You can also repeat any number of actions. Let's learn today. Undo, Redo, and Redo in Excel 2010:

Undo the previous or multiple actions that you performed, to undo the action, do one or more of the following:

Click Undo on the Quick Access Toolbar.

Undo

Keyboard shortcuts, you can also press ctrl+z.

To undo multiple actions at the same time, click the arrow next to undo, select the action you want to undo from the list, and then click the list. Excel undoes all the selected actions.

Before you press ENTER, you want to cancel the cell or formula bar Edit bar: The bar at the top of the Excel window for entering or editing values or formulas in a cell or chart. Constant values or formulas stored in the active cell are displayed in the formula bar. , press ESC.

Comments

Some actions cannot be undone, such as clicking any Microsoft Office buttons command or saving a workbook. If the action cannot be undone, the Undo command becomes "cannot be undone."

Macros can clear all items in the Undo list.

Redo the Undo action

To redo the undo action, click Recover on the Quick Access Toolbar.

Keyboard shortcuts can also be pressed ctrl+y.

Note: The restore command changes to repeat when all undone actions are restored.

Repeat previous action

To repeat the previous action, click Repeat on the Quick Access Toolbar.

Repeat

Keyboard shortcuts, you can also press Ctrl+y.

Note If some operations cannot be duplicated, such as using a function in a cell. If you cannot repeat the previous action, the repeat command changes to "cannot be repeated." Have you learned all of these simple undo, redo, and repetitive operations?