Microsoft Excel provides us with numerous system features to perform operations in the blink of an eye! There are a lot of Excel functions that are used to build up formulas to perform any task in an Excel sheet. Sometimes you may have performed an action or entered a formula on your worksheet but mistakenly you have undone the action. If you want to recover the task, you don’t need to re-apply them because Excel allows you to redo an action you have undone. In this article, I will show you how to redo an action in an Excel sheet.
Download Practice Workbook
You can download the practice book from the button below.
2 Quick Ways to Redo in an Excel Sheet
In this section, you will find 2 easy and quick ways to redo an action in an Excel sheet. So, let’s check them now!
1. Keyboard Shortcut to Redo an Action
Let’s say, we have got a dataset of grade percentages of different subjects of a student. Our aim is to calculate the average grade percentage of that student.
In order to show the process of performing a redo to an action, proceed with the following steps.
- First of all, let’s calculate the average percentage by applying the function.
- At that time, let’s say, you have pressed CTRL+Z and Excel has undone this action.
- Now, in order to recover this action, you don’t need to apply the task again. All you have to do is to press CTRL+Y to redo the action and your cell will again return the value.
So, In this way, you can redo an action in your Excel sheet with the help of a keyboard shortcut.
2. Redo in Sheet from Quick Access Toolbar
You can also recover the action that has been undone by just using the shortcut key from the Quick Access Toolbar. You can customize the Quick Access Toolbar for adding a command to this section. Excel provides two different keys from the toolbar for serving this purpose. Let’s demonstrate the use of these keys one by one.
2.1. Using Redo Key
In the Quick Access Toolbar, the Redo key exists to reperform an action immediately after being undone. Follow the steps for using this key.
- First of all, find the Redo key on the toolbar. Usually, it exists by the side of the undo key.
- Then, just click on the key to Redo the undone action.
So easy, isn’t it?
2.2. Using Repeat Key
You can also use the Repeat key to avoid re-apply for the task. The Repeat key may not exist in the ribbon. In order to allow the toolbar to show the ribbon, follow the steps below.
- Firstly, click on the Customize Quick Access Toolbar option> choose More Commands.
- Then, a box will appear. Here, select Commands Not in the Ribbon.
- Now, now some commands will appear. Choose the Repeat command> click Add.
- After that, Customize Quick Access Toolbar icon will show the Repeat command. Click OK.
- Finally the Repeat key will be available on the toolbar. Click to redo your task.
Advantages of Performing Redo in Excel Sheet
The Redo feature allows the quick reverse of the Undo action. In case of a long duration of operation that is being undone, the shortcut key of redoing the task saves time and makes it user-friendly.
Things to Remember
- The Redo key and Repeat key will never be available at the same time.
- The Repeat key will be available to perform the task only when you will make a change to your current working sheet.
- When you perform an action in Excel and then undo it, your Redo button will only be available at that time.
- For some versions of Excel, the Repeat key and the Redo key may denote the same symbol in the ribbon.
In this article, I have tried to show you some methods about how to redo in an Excel sheet. I hope from now on you can quickly redo an action in an Excel sheet. If you have better methods, questions, or feedback regarding this article, please don’t forget to share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy. Have a great day!