Redo Shortcut in Excel

MS Excel is one of the most popularly used spreadsheets in the world. It has gained immense popularity since the day it was launched for the common people. Most of the sectors have adopted Excel because it eases the workload and has various built-in features.

One of those built-in features is the redo feature, which is commonly used in Excel along with the undo option. I generally use these features to rectify my mistakes by repeating an action that was once undone. It helps me a lot when I am working on tedious projects with tight deadlines.

While working on Excel I often used to take help of the undo feature to rectify my mistakes. Later on, I discovered that the undo action can also be canceled with the help of the redo feature in Excel. Now, after discovering this feature, I can easily and rapidly rectify my mistakes.

In this article, I am going to give you detailed guidance about the redo shortcut in Excel. This article will deal with the different redo shortcuts that work on Windows and macOS so that you do not face any difficulties while working on Excel. You can also take online courses to elevate your Excel proficiency and career trajectory!

Let’s dive into this article to learn more!

How can You use Redo in MS Excel?

As I have already stated, the redo feature in MS Excel is used to repeat an action that has been undone. Now you might be wondering from where you can do this redo feature. Now, I will guide you step-by-step in using the redo feature in MS Excel.

• Step 1: Open MS Excel and select a blank spreadsheet.

• Step 2: After a blank spreadsheet opens, you will immediately see the quick access toolbar right on the top. The redo button is placed right adjacent to the undo button.
  

• Step 3: The redo button on the quick access toolbar comes with a drop-down option that shows all the possible actions that can be redone in the spreadsheet. The drop-down option makes your work easier as it will help you to decide which action you want to redo first.

This is the redo feature that is available on the quick access toolbar of MS Excel. In the next segment, I will guide you through the redo shortcut in Excel that will automatically elevate your work quality.

Redo Shortcut in Excel

In my years of experience, I have observed that while working on MS Excel it is easier to use the redo and undo features with the help of its shortcuts rather than finding them from the taskbar. It saves time and enhances the pace of your work. Now, I will explain how to undo and redo shortcut in Excel.

To use the redo shortcut in Excel, you must use the undo shortcut for once. “CTRL+Z” is the shortcut key for undoing in Excel. It is used to reverse the immediate action deleted from Excel. 

At times, while working I have faced instances where the action that I had done was not wrong and needs to be redone.In such situations redo shortcut in Excel acts as a savior. 

To use redo short in Excel we need to press the control key and alphabet Y key together. This means “CTRL+Y” must be pressed together to perform the redo action in Excel.

However, “CTRL+Y” is applicable as the redo shortcut only in Windows. In macOS, these keys will not work as the redo shortcut. Therefore, if you are working on a macOS, you must use the command key, shift key, and Z key together to perform the redo action.

Source: OSXDaily

Similarly, “CTRL+Z” does not work as undo in macOS. Hence, while working on macOS you must press the command key and Z key together to perform undo action.

Source: OSXDaily

Example

Let me clear your doubts regarding the redo feature with the help of an example. Here I will use the RANDBETWEEN function for further illustration. First, I will add a random number inside the A1 cell and drag the cursor to C10.

In the next step, I will add some color to the cells.

Now, I will use the undo feature with the help of CTRL+Z keys.

After using the Undo feature, you can see the color applied to cells has disappeared. Now, I use the Redo feature so that the last action we have undone can be re-done. To perform that I will use the Redo shortcut in Excel that is CTRL+Y.

The last action has been redone successfully using the CTRL+Y key. You can also use the Redo feature from the quick access toolbar which is present in MS Excel. As a beginner, if you want to learn more about the redo feature in MS Excel then you must go through various online courses for further understanding.

Limitation of Redo in Excel

The redo feature in MS Excel works like a savior during my day-to-day activities. In my long years of working with Excel, I have discovered that this feature has certain restrictions where it can not be used. Here is the list of restrictions that I usually face:

• Unless an action has been affected by the undo feature you can not perform the redo feature on it.
• You can easily use the redo feature for your last 100 actions on MS Excel.
  

Conclusion

As soon as you start working in any sector, you have to work on MS Excel regularly. Learning the redo shortcut in Excel will help you to elevate your working pace and rectify the mistakes you make within seconds. You do not have to re-type the words or sentence that you have undone, you just need to click on the redo option on the quick access toolbar or need to press “CTRL+Y” to revert the last action you require.

Excel skills are mandatory, especially if you are pursuing a career in the corporate sector. upGrad offers not only expertly designed Excel tutorials and courses but also other relevant data science courses. Hurry up and enrol yourself in these tutorials to bag lucrative opportunities!

Frequently Asked Questions (FAQs)

What is redo in Excel?

When you have undone something recently in Excel but immediately realize it is not a mistake. Then you can use the redo feature to bring back the original input that was deleted.

What is shortcut for redo?

The redo shortcut in Excel is “CTRL+Y” if you are using Windows or you must use “Command+Shift+Z” if you are using macOS. By pressing these keywords you can easily repeat the action you had mistakenly deleted by using the undo feature.

What is the opposite of Ctrl Z in Excel?

“CTRL+Z” in Excel is used for undo. Therefore, the opposite of this action would be “CTRL+Y” which is redo.

Which shortcut can you use for undo and redo Excel?

To redo Excel shortcuts you have to use the “CTRL+Y” keys. On the other hand, for the undo shortcut, you have to use the “CTRL+Z” keys.

Why is redo used?

Redo in Excel is used to re-do the previous action that has been mistakenly deleted or removed. It cancels out the action performed by undo.

What is Ctrl A to Z used for?

Keys from “CTRL+A” to “CTRL+Z” are used for various shortcuts that can be used to run multiple features in MS Excel. For example, “CTRL+A” is used to select the entire text, “CTRL+X” is used to cut a sentence or word, “CTRL+V” is used to paste a copied text, “CTRL+P” is used to take any print, “CTRL+C” is used to copy one sentence or word in Excel, etc.

What is redo in word?

Redo in Word re-does the action that a user has undone. It acts just the opposite of redo.

What is redo on computer?

In computer, redo means restoring the previous action that was deleted. Undo and redo together make work easier.

What is the control Y shortcut?

Control Y or “CTRL+Y” shortcut performs redo action on MS Word or Excel. It makes the work easier for a user.