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

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.

Redo in an Excel Sheet

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.

Redo in an Excel Sheet

  • At that time, let’s say, you have pressed CTRL+Z and Excel has undone this action.

Redo in an Excel Sheet

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

Redo in an Excel Sheet

So, In this way, you can redo an action in your Excel sheet with the help of a keyboard shortcut.

Read More: How to Undo and Redo in Excel (2 Suitable Ways)


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.

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.

Redo in an Excel Sheet

So easy, isn’t it?

Read More: How to Undo Changes in Excel after Save and Close (2 Easy Methods)


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

Read More: [Fixed!] Undo and Redo in Excel Not Working (3 Simple Solutions)


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.

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. For more queries, kindly visit our website ExcelDemy. Have a great day!


Related Articles

Rafi

Rafi

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 worktime and made it easy for us to 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

Leave a reply

ExcelDemy
Logo