# How to Redo in an Excel Sheet (2 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

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 it 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.

## How to Redo in an Excel Sheet: 2 Quick Ways

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.

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.

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.

Steps:

• 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.

Steps:

• 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, 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 for 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 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.

## Conclusion

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. Have a great day!

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Hasan

Hey there! I am Md. Rafiul Hasan. Currently, I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our work time and made it easy for us to perform quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF