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 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 shortcut key i.e. “Ctrl + Y”.
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 Toolbar (QAT) we have icons for both “UNDO” & “REDO”.
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”.
Step 3: Now it will open up the “Excel Options” window, from this, choose “Quick Access Toolbar”.
Step 4: Now choose “Commands Not in the Ribbon” from the drop-down list of “Choose Commands from:”
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 >>”.
Step 6: Now do the same for “UNDO” as well. After adding the commands click on “Ok”
Step 7: We will have selected commands in the 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.
Ok, let’s see how we can perform REDO action in excel.
First I will perform some actions in excel, let’s say using the RANDBETWEEN function I will insert some number in cell A1.
Now I will copy-paste the above formula to the range of cells from A1 to C10.
So far two actions are performed, now I will change the font name to “Verdana” and the font size to 10.
Now I will change the background color of these cells.
Now final action will be, copy and do paste special as values.
Ok, now excel has recorded all the actions we have performed. Now data range is without formulas.
Now upon pressing the UNDO key Ctrl + Z, it will bring back the previous action i.e. we will get back formulas.
Since one action is undone now we can perform REDO action of going forward to the paste special values action using the shortcut key “CTRL + Y” or pressing the icon on QAT.
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.
Now by clicking on the last action in the UNDO button, we can go back to the actual first step.
If you press Ctrl + Y shortcut for 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 the specific set of actions.
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 –