Tutorial Playlist
68 Lessons1. Excel Tutorial
2. Excel Worksheet for Practice
3. Google Sheets Vs. Excel
4. Excel Shortcut Keys
5. Excel Keyboard Shortcuts
6. Excel AutoSum Shortcut
7. Redo Shortcut in Excel
Now Reading
8. Charts in Excel
9. Pivot Charts in Excel
10. Excel Sum Formula
11. Excel Percentage Formula
12. Excel Age Calculation Formula
13. Excel Range Formula
14. Round Off Formula in Excel
15. VLOOKUP Formula in Excel
16. Excel Transpose Formula
17. Average Equation in Excel
18. How to Use DATEDIF Formula in Excel
19. IRR Formula in Excel
20. Standard Deviation Formula
21. Excel Age Calculation Formula
22. Excel MAX Function
23. Excel LEFT Function
24. Excel RIGHT Function
25. Trim Function In Excel
26. LookUp function in Excel
27. Columns in Excel
28. How To Sort Data In Excel
29. How To Freeze Panes in Excel
30. Page Setup in Excel
31. How to Recover an Unsaved Excel File
32. Concatenate in Excel
33. Count In Excel
34. IF Condition In Excel
35. H LOOK UP in Excel
36. How Do You Move Columns in Excel
37. Split Cells in Excel
38. Remove Blank Rows in Excel
39. How To Lock Cells in Excel
40. Data Validation in Excel
41. How to Insert Checkbox in Excel
42. How To Highlight Duplicates in Excel
43. Fill Series in Excel
44. How to Create Excel Drop-Down List
45. What-If Analysis in Excel
46. How to Use SUMIFS Function in Excel
47. INDIRECT Function in Excel
48. Pivot Table in Excel
49. Slicers in Excel
50. How to Create a Dashboard in Excel
51. Excel Data Cleaning
52. Data Analysis In Excel
53. Goal Seek in Excel
54. Solver in Excel
55. Power Query in Excel
56. Macros In Excel
57. How To Make Graph in Excel
58. How To Make Histogram In Excel
59. How To Convert PDF to Excel Without Software
60. Barcode Font For Excel
61. Gantt Chart in Excel
62. Excel RANK function
63. AND Function in Excel
64. How to Calculate NPV
65. Format Painter in Excel
66. Count Colored Cells in Excel
67. Amortization Schedule in Excel
68. Master Cell References 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!
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.
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.
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
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.
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:
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!
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.
Devesh
Passionate about Transforming Data into Actionable Insights through Analytics, with over 3+ years of experience working in Data Analytics, Data V…Read More
Talk to our experts. We’re available 24/7.
Indian Nationals
1800 210 2020
Foreign Nationals
+918045604032
upGrad does not grant credit; credits are granted, accepted or transferred at the sole discretion of the relevant educational institution offering the diploma or degree. We advise you to enquire further regarding the suitability of this program for your academic, professional requirements and job prospects before enrolling. upGrad does not make any representations regarding the recognition or equivalence of the credits or credentials awarded, unless otherwise expressly stated. Success depends on individual qualifications, experience, and efforts in seeking employment.
upGrad does not grant credit; credits are granted, accepted or transferred at the sole discretion of the relevant educational institution offering the diploma or degree. We advise you to enquire further regarding the suitability of this program for your academic, professional requirements and job prospects before enr...