How to add the undo button in Microsoft Excel
The Undo feature in Excel is a tool that allows users to reverse their previous actions. It is an essential feature that helps users correct mistakes and undo changes they made unintentionally. The Undo button is located on the Quick Access Toolbar in Excel and can be accessed by clicking on the icon or by using the keyboard shortcut Ctrl + Z.
In this tutorial, we will learn how to add the undo button in Microsoft Excel. There are two methods to incorporate the undo button in Microsoft Excel. The undo function is readily available in the “Quick Access Toolbar”; however, if it is not visible, it can be added by accessing the “Options” located in the File tab. Alternatively, the “Customize Quick Access Toolbar” shortcut button in the ribbon can be utilized to add the undo button.
Method 1: Adding the Undo Buttons using “Options” in the File Tab
Step 1 – Go to the File Tab
![](https://spreadcheaters.com/wp-content/uploads/Method-1-Step-1-How-to-add-the-undo-button-in-Microsoft-Excel-1024x603.png)
- Go to the File tab in the menu bar.
Step 2 – Click on the Options Button
![](https://spreadcheaters.com/wp-content/uploads/Method-1-Step-2-How-to-add-the-undo-button-in-Microsoft-Excel-1024x731.png)
- Click on the Options button in the bottom left of the File tab.
Step 3 – Click on “Quick Access Toolbar”
![](https://spreadcheaters.com/wp-content/uploads/Method-1-Step-3-How-to-add-the-undo-button-in-Microsoft-Excel-1024x563.png)
- Click on “Quick Access Toolbar” in the menu at the left of the dialog box.
Step 4 – Locate and Add the Undo Button
![](https://spreadcheaters.com/wp-content/uploads/Method-1-Step-4-How-to-add-the-undo-button-in-Microsoft-Excel.gif)
- Locate and Add the Undo button in the “Choose commands from” list.
- The commands are listed in alphabetic order.
- To add the Undo button, select the Undo option in the list and click on the Add button.
Step 5 – Click on OK
![](https://spreadcheaters.com/wp-content/uploads/Method-1-Step-5-How-to-add-the-undo-button-in-Microsoft-Excel-1024x620.gif)
- Click on OK in the dialog box.
- The Undo button will be added.
Method 2: Adding the Undo Button Using the “Customize Quick Access Toolbar” Shortcut
Step 1 – Enable the Quick Access Toolbar
![](https://spreadcheaters.com/wp-content/uploads/Method-2-Step-1-How-to-add-the-undo-button-in-Microsoft-Excel-1024x505.gif)
- Click on the “Ribbon Display Option” arrow at the bottom right of the ribbon.
- A list will appear, click on the “Show Quick Acces Toolbar” option in the list.
- Quick Access Toolbar will appear.
Step 2 – Click on the “Customize Quick Access Toolbar” Shortcut List Arrow
![](https://spreadcheaters.com/wp-content/uploads/Method-2-Step-2-How-to-add-the-undo-button-in-Microsoft-Excel-1024x599.png)
- Click on the “Customize Quick Acces Toolbar” shortcut list arrow in the Quick Access Toolbar.
- A drop-down list will appear.
Step 3 – Click on the Undo Option
![](https://spreadcheaters.com/wp-content/uploads/Method-2-Step-3-How-to-add-the-undo-button-in-Microsoft-Excel-1024x632.gif)
- Click on the Undo option in the drop-down list.
- The Undo button will be added.