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.”
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. (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.
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. 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 the 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 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.
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 –