Redo Shortcut in Excel

Shortcut for Redo in Excel

Mistakes are quite common in excel, so to rectify this, we have an option called “Undo” by using Ctrl + Z. In often case, we may undo an action, but later we may recognize that that was not actually a mistake, so we need to go back to the original point before we undo the action, so canceling the undo action is called as “Redo” in excel

In excel, to redo the undone action, we have a shortcut key, i.e., “Ctrl + Y.”

Excel Redo Shortcut

We all know to correct the mistakes we have done in software’s there is a shortcut key “Ctrl + Z,” which undo the mistake we have performed.

Mistakes are quite common while working but having to undo them is possible in excel. Recently I have seen a slogan on auto-rickshaw saying, “Do not make mistakes in life because life doesn’t have Ctrl + Z.” This is what we need to keep in mind in our practical life.

Ok, let’s get back to the article topic, i.e., “Excel Shortcut Redo.” In this article, we will show you the opposite of Ctrl + Z to redo the action in excel.

I don’t know whether you have noticed or not in Quick Access ToolbarQuick Access ToolbarQuick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. It enables users to save important shortcuts and easily access them when needed.read more (QAT), we have icons for both “UNDO” & “REDO.”

Undo & Redo Option

We can use this QAT to perform actions, or we can also use shortcut keys also to perform these tasks.

If you do not have the above icons on your QAT, follow the below steps to activate them by customizing the too bar.

Step 1: Go to the FILE tab in the ribbon.

Step 2: Now, click on “OPTIONS” under “FILE.”

Excel Option

Step 3: Now, it will open up the “Excel Options” window; from this, choose “Quick Access Toolbar.”

Redo Shortcut - Choose QAT

Step 4: Now choose “Commands Not in the Ribbon” from the drop-down list of “Choose Commands from:”

Redo Shortcut - Commands not in Ribbon

Step 5: Now, we can see commands which are not in the ribbon. Since these things are organized alphabetically, first find the “REDO” option. After selecting the command, click on “Add >>.”

Redo Shortcut - Choose Redo Option

Step 6: Now, do the same for “UNDO” as well. After adding the commands, click on “Ok.”

Redo Shortcut - Choose Undo Option

Step 7: We will have selected commands in the QAT.

QAT

Like this, we can customize the Quick Access Toolbar (QAT).

How to Use the Redo Shortcut in Excel?

UNDO & REDO are brothers in excel; we can recognize UNDO as the big brother and REDO as the younger brother. The reason why I have told this is because, without REDO, the UNDO option can be performed, but without UNDO, we cannot perform the REDO option.

If nothing is UNDONE in excel, then there is no question of REDO the something, so that is why REDO can be performed only after UNDO has been performed.

Below are the shortcut keys for UNDO & REDO in excel.

Shortcuts

Ok, let’s see how we can perform REDO action in excel.

Example

First, I will perform some actions in excel; let’s say using the RANDBETWEEN function, I will insert some number in cell A1.

Redo Shortcut - Example 1.1

Now I will copy-paste the above formula to the range of cells from A1 to C10.

Redo Shortcut - Example 1.2

So far, two actions are performed, now I will change the font name to “Verdana” and the font size to 10.

Redo Shortcut - Example 1.3

Now I will change the background color of these cells.

Redo Shortcut - Example 1.4

The final action will be, copy, and do paste specialPaste SpecialPaste special in Excel allows you to paste partial aspects of the data copied. There are several ways to paste special in Excel, including right-clicking on the target cell and selecting paste special, or using a shortcut such as CTRL+ALT+V or ALT+E+S.read more as values.

Redo Shortcut - Example 1.5

Ok, now excel has recorded all the actions we have performed. Now data range is without formulas.

Redo Shortcut - Example 1.6

Now upon pressing the UNDO key Ctrl + Z, it will bring back the previous action, i.e., we will get back formulas.

Redo Shortcut - Example 1.7

Since one action is undone now, we can perform the REDO action of going forward to the paste special values action using the shortcut key “CTRL + Y” or pressing the icon on QAT.

Redo Shortcut - Example 1.8

As you can see above, we have only values in place.

We have performed 7 activities; to come back to the first step, we may need to type ‘Ctrl + Z’ 7 times; instead, we can use the UNDO icon in QAT and see all the actions that we have performed here.

List of Activities Performed

Now by clicking on the last action in the UNDO button, we can go back to the actual first step.

First Step

If you press Ctrl + Y shortcut for a redo, then it will bring back the action of the next step performed after entering the formula.

Like this, we can UNDO or REDO the actions in excel using simple shortcut keys.

Things to Remember

  • To perform REDO, one must have performed UNDO action, so without undoing an action, we cannot perform the REDO option.
  • Using QAT icons, we can actually go back or go forward to a specific set of actions.

Recommended Articles

This has been a guide to Redo Shortcut in Excel. Here we discuss how to use undo and redo commands along with step by step examples and explanation. You can learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>