Undo and Redo in Excel on Windows — Full Guide

The average Excel user makes roughly 40 edits per hour. That's not a problem, until one of those edits goes wrong and there's no clean way back. Knowing how to undo and redo in Excel on Windows isn't a nice-to-have. It's the difference between a two-second fix and a ten-minute panic.

I've been working in Excel daily for over 12 years as a Senior Operations Analyst, and I still use Ctrl+Z more than almost any other shortcut. Not because I'm sloppy. Because I'm fast. Moving fast means occasionally moving wrong, and undo is what makes speed safe.

What You'll Fix and What to Know Before You Undo in Excel on Windows

Undo and redo let you step backward or forward through your editing history in Microsoft Excel: deleted data, changed formatting, moved cells, typed-over values. By the end of this guide, you'll know the shortcuts cold, know how to raise the undo limit, and know exactly why undo sometimes goes dark on you.

A few things worth knowing upfront. Excel's undo history defaults to 100 actions, which covers most sessions easily. Saving your file does not clear the undo stack, a fact that surprises a lot of people. But running a macro does. If you trigger a macro and then try to undo, the stack is gone. Completely. That's the gotcha that catches intermediate users off guard, and we'll cover it properly in Step 3.

These steps apply to Microsoft 365 and Excel 2016/2019 on Windows. Some shortcut behavior varies slightly by version, and I'll flag it where it matters.

---

Step 1: Use the Undo and Redo Shortcuts in Excel (Ctrl+Z and Ctrl+Y)

This is the core of it. No menus. No clicking around. Two shortcuts handle 95% of what you need.

1. Press Ctrl+Z to undo your last action. Press it again to undo the action before that. Each press steps back one action through your undo history.
2. Press Ctrl+Y to redo, meaning to re-apply an action you just undid. If you undid three steps and only needed to undo two, Ctrl+Y brings the third one back.
3. Keep pressing either shortcut to move further back or forward through your history.

One thing to watch: Ctrl+Y isn't always redo. If you haven't just undone something, Excel interprets Ctrl+Y as Repeat, which repeats your last action rather than restoring one. That distinction trips people up, and I'll cover it more in the Common Mistakes section. In newer Microsoft 365 builds on Windows, Ctrl+Shift+Z is mapped specifically to redo, which removes the ambiguity. (Behavior confirmed in Excel 2016, 2019, and Microsoft 365.)

Using the Quick Access Toolbar If Shortcuts Aren't Working

The Quick Access Toolbar sits above the ribbon by default. You'll see the curved undo arrow there. Click the small dropdown arrow next to it and you get a stacked list of your recent actions. You can click any item in that list to undo everything back to that point at once.

The catch: selecting step 8 on that list undoes all eight steps above it, not just that one. It's an all-or-nothing jump to that point in history. Useful when you know you need to go back several moves. Dangerous if you forget how it works.

If the undo button isn't showing in your toolbar at all, right-click anywhere on the Quick Access Toolbar and choose Customize Quick Access Toolbar. Add Undo and Redo from the list of popular commands.

---

Step 2: Increase Your Undo Levels in Excel Beyond the Default 100

Once you've got the shortcuts working, you might want more headroom than 100 steps, especially in long editing sessions. Here's where to change it.

1. Go to File > Options > Advanced.
2. Scroll down to the Editing options section.
3. Find Maximum number of undos and change the value. The range is 1 to 100 by default, but you can push it higher.
4. Click OK and restart Excel for the change to take effect.

Be honest with yourself about the trade-off here. Excel stores every undoable action in memory. If you run 10 large operations on a workbook with a million cell values and you've set your undo limit to 300, you're asking Excel to hold a significant chunk of data in RAM. On a lean machine or a large file, that slows things down noticeably. For most users working with everyday-sized files in 2026, 150 steps is plenty. I keep mine at 100 (the default) because my production workbooks are large and I'd rather have speed.

---

Step 3: Fix Undo When It's Greyed Out or Broken in Excel

With the limit adjusted and shortcuts in place, there's one more scenario that will eventually catch you: undo goes grey and stops responding entirely. Here's what's actually happening and how to handle it.

The three most common causes of undo being greyed out in Excel are a shared workbook (legacy co-authoring mode disables undo), a macro that just ran, or simply hitting the undo limit. The first two are the ones people don't expect.

If you're in a shared workbook (Review > Share Workbook), undo is disabled by design. Unsharing the workbook restores it, but that may not be an option if others are in the file. This is one of the reasons I avoid the legacy shared workbook feature whenever possible; the modern co-authoring in Microsoft 365 handles this much better.

When a Macro Has Cleared Your Undo History

Running a macro wipes the undo stack immediately. Every action you took before the macro ran is gone from history. This isn't a bug. It's how Excel handles VBA operations, which can affect thousands of cells in ways the undo engine can't reliably reverse.

Here's the fix when you've blown past undo entirely: go to File > Info > Manage Workbooks. Excel's AutoRecover feature saves periodic versions of your file. If a version exists from before the macro ran, you can open it and recover your prior state. It's not perfect (the gap between autosaves can be 10 minutes), but it's the best fallback available when undo is gone.

For workbooks that matter, save a manual backup copy before running any macro that modifies data. Takes five seconds. Worth it every time.

If you're newer to Excel and want to build out these habits from the ground up, the Excel for Beginners complete starter guide covers the foundational workflow that makes features like undo actually stick.

---

Common Mistakes Using Undo and Redo in Excel on Windows

The most common mix-up is treating Ctrl+Y as pure redo. It isn't. If you haven't just undone something, Ctrl+Y repeats your last action, same as F4. Type "Q" in a cell, hit Ctrl+Y, and Excel types "Q" again in the next selected cell. That's Repeat, not Redo. The distinction matters, and it's caught more than a few people off guard. Ctrl+Shift+Z is the cleaner choice in Microsoft 365 if you want redo and nothing else.

The second trap: running a macro and then reaching for Ctrl+Z. The stack is already gone. It doesn't matter that you just ran the macro two seconds ago, undo history resets the moment VBA executes. If you're in a workflow that involves macros and manual edits, save before you run. Every time. No exceptions.

Third: setting undo levels too high on a large file. I've seen people set it to 500 thinking more is always better. On a workbook with heavy data, that taxes memory and can cause sluggish response across the whole file. Raise the limit thoughtfully. Not to the maximum just because you can.

People aren't undertrained because they're careless. They're undertrained because nobody showed them.

Features like undo history, the QAT dropdown, and AutoRecover exist in every copy of Excel, and most users have never touched them. If this was useful, the Excel Basics for Beginners, Advanced Edition goes deeper on the kinds of features that change how confidently you work in Excel day to day.

And if you want to go further with recovery habits (like saving versions correctly before they matter), saving your Excel workbook properly is worth reading alongside this one.

---