You can use the Undo function in Excel to revert anything you might type or change on the page, including inserting a numeric value in a spreadsheet cell, changing a formula, applying a cell font or background color, typing and deleting text. Unlike with Apple’s more generalized undo methods on touchscreen devices like the iPhone and iPad, Microsoft provides two easy and direct ways of solving the issue of how to undo in Microsoft Excel: the Quick Access Toolbar, and the universal keyboard commands.
- How To Undo in Microsoft Excel using Quick Access Toolbar
- How To Undo in Microsoft Excel using Keyboard Commands
How To Undo in Microsoft Excel using Quick Access Toolbar
The default location of the Quick Access Toolbar is inside the title bar of the Excel application window, but it can also be configured to display below the ribbon. In addition to giving you quick access to common Excel commands, the toolbar also includes a customizable drop-down menu that contains the complete set of default commands you can toggle on or off in the bar. Fortunately for us, the Undo and Redo buttons are enabled by default.
- Access the Undo command by clicking on the undo ↩ button on the Quick Access Toolbar.
The Undo command button also has a drop-down menu that lets you review the past several actions you’ve performed that that can be undone, and clicking on one of them will undo all actions back to that point.
Once you have undone a particular action, if you decide that you wanted that change after all you also have the option to redo your last action. The redo button is also in the Quick Access Toolbar.
Access the Redo command by clicking on the redo ↪ or ↻ button on the Quick Access Toolbar.
The buttons will also work with text that you’ve pasted in, images or movie media that you have placed on the page, background color and heading changes, and most other types of actions in Excel. You can continue click the button to undo multiple times if needed.
How To Undo in Microsoft Excel using Keyboard Commands
Just as with any Microsoft Office software program or most Windows and Macintosh programs in general, you can use standard keyboard commands to perform undo and redo actions. The keyboard commands will work the same way as pressing the button in the quick access toolbar, making it a very quick way to undo a numeric entry into a cell, for example. Note that certain actions cannot be undone with either method, such as saving your spreadsheet.
To undo in Microsoft Excel on Windows,
- Press Ctrl+Z for undo.
- Press Ctrl+Y for redo.
And, to perform the same commands on a Mac,
- Press Cmd ⌘+Z for undo.
- Press Cmd ⌘+Y for redo.
Conclusion: So, How To Undo in Microsoft Excel? Use the quick access toolbar or keyboard shortcuts.
For more information on Microsoft Excel, visit Microsoft’s site. If you want to know how to undo on other devices, check out the other articles on our site for more information. Happy undo-ing.