Excel can be a bit intimidating, especially if you’re new to it. But one of the great things about this powerful tool is its ability to let you easily fix mistakes or redo tasks with just a couple of clicks. Whether you accidentally delete something important or need to repeat a recent action, Excel’s Undo, Redo, and Repeat commands have got your back. In this guide, we’ll break down how to use these features step-by-step.
Undo: Taking Back Your Last Move
The Undo feature is a lifesaver when you’ve just made a mistake. Maybe you deleted the wrong row or changed a number you didn’t mean to. No worries—Undo lets you reverse the action immediately.
How to Undo:
- Keyboard Shortcut: Simply press
Ctrl + Z
(Windows) orCommand + Z
(Mac). This will undo your last action. - Undo Button: Look for the Undo button in the top-left corner of the Excel window. It looks like a curved arrow pointing left. Each time you click it, Excel will reverse the last action you took.
You can keep hitting Ctrl + Z
or clicking the Undo button to undo multiple actions. Excel typically remembers a good number of recent actions, so you’re covered for several steps back.
Pro Tip:
Undo doesn’t just apply to cell edits! You can use it to undo formatting changes, row/column deletions, and even formula edits.
Redo: Bringing Back What You Undid
Now, what if you undo something and realize you actually wanted it back? That’s where Redo comes in. The Redo function lets you bring back the action you just undid.
How to Redo:
- Keyboard Shortcut: Press
Ctrl + Y
(Windows) orCommand + Y
(Mac). This will redo the last undone action. - Redo Button: Look for the Redo button next to the Undo button. It looks like a curved arrow pointing right.
Like Undo, you can use Redo multiple times to bring back several undone actions in the order you reversed them.
Repeat: Doing the Same Action Again
The Repeat function is a bit different but equally helpful. It allows you to perform the same action again without having to redo the whole process manually. For instance, if you’ve just formatted a cell in bold and want to apply the same formatting to another cell, you can use Repeat.
How to Repeat an Action:
- Keyboard Shortcut: Press
F4
(Windows) orCommand + Y
(Mac). This will repeat the last action you took.
Example:
Let’s say you’ve just highlighted a cell in yellow. To repeat the same action on another cell, click on that cell and press F4
. It’ll apply the yellow highlight without you having to manually go back into the formatting options.
Key Differences Between Redo and Repeat
While they sound similar, Redo and Repeat serve different purposes:
- Redo restores an action you undid.
- Repeat duplicates the last action you performed.
Mastering Undo, Redo, and Repeat can save you tons of time and hassle when working in Excel. Whether you’re fixing mistakes, retracing your steps, or streamlining repetitive tasks, these features are simple to use and incredibly helpful.
By using just a few keyboard shortcuts or buttons, you can undo accidental changes, bring back undone work, or repeat the same task effortlessly. So next time you find yourself in a pinch, you know exactly what to do!