When you work in Excel you may make mistakes and need to undo or redo the last actions. You can easily undo or redo the last action in Excel. This article guides you on how to use the undo and redo feature in Excel.
How to use Excel Undo
Excel undo helps you to return to the previous step. You may need to undo the action in many real-time situations such as after deleting a cell value, row, column, edit the formula, sort, and filter data.
You can see the undo button in the QAT Quick Access Toolbar at the top left corner of the Excel next to the Save button. you just press the button to undo the last action. If you want to undo multiple previous actions, just press the button as many times as you need.
You can use the Ctrl + Z to undo the last action in Excel If you like to use keyboard shortcut keys. Undo action will not work when you execute any macro in the Excel workbook.
How to use Excel Redo
Excel Redo is exactly the opposite of the undo action in Excel. It repeats the last action in Excel. You can see the Redo button in the QAT Quick Access Toolbar at the top left corner of the Excel next to the Undo button. you just press the button to redo the last action.
If you like to use keyboard shortcut keys, you can use the Ctrl + Y or Press function key F4 to redo the last action in Excel.
Conclusions
The Excel Undo and Redo features help the user to correct their mistakes, experiment with different scenarios, and restore the previous states of their workbooks. It also saves time & effort and allows them to quickly revert or repeat actions without having to redo them manually.
I hope this blog post has helped you to understand how to use undo and redo in Excel. If you have any questions or feedback, please leave a comment below.
