How to Undo in Excel: Shortcuts, Limits & Recovery 2026

You just deleted three rows of customer data. Or pasted the wrong column over a quarterly forecast. Or accidentally sorted a table that ruined every formula linked to it. Whatever the mistake, the fix is almost always the same — undo it. Excel's undo feature is one of those tools you barely think about until you really need it, and then it becomes the most important button on your screen.

Knowing how to undo in Excel isn't just about clicking the curved arrow at the top of the window. There are keyboard shortcuts that save hours, multi-step rollbacks that recover entire workflows, and limits you should understand before you bet your spreadsheet on them. This guide walks you through every undo method — desktop, web, Mac, and mobile — plus the redo trick most people miss and what to do when undo simply won't work.

The fastest way to undo in Excel

Press Ctrl + Z on Windows or Cmd + Z on Mac. That's it. One keystroke reverses your most recent action, whether it was typing a value, deleting a cell, applying a format, or pasting content. Hit it again to undo the action before that. Keep tapping it and you'll walk backward through your edits in reverse order, one step at a time.

If you prefer the mouse, look at the Quick Access Toolbar — that small strip of icons above or below the ribbon. The curved arrow pointing left is undo. Click it once for the most recent change, or click the tiny dropdown next to it to see a list of recent actions and undo several at once.

Why the keyboard shortcut wins

You'll work faster with Ctrl + Z because your hands stay on the keyboard. Mouse-based undo costs you a context switch every time. When you're cleaning up a messy import or testing different formulas, the difference adds up to minutes per session — sometimes more.

Undoing multiple actions at once

Excel keeps a running history of your recent edits, and you don't have to undo them one keystroke at a time. Click the small arrow next to the undo button on the Quick Access Toolbar — a dropdown appears showing the last batch of actions, with the most recent at the top. Hover down the list and Excel highlights every step that will be reversed. Click on the action you want to roll back to, and everything above it disappears in one shot.

This is gold when you've done a chain of edits and realized the whole sequence was wrong. Rather than mashing Ctrl + Z and trying to count, you pick a stopping point visually. Just remember Excel can't undo selectively — you can't pick action #3 from five steps back without also undoing #1 and #2. Undo is strictly chronological.

How to redo (and why it matters)

Pressed Ctrl + Z one too many times? Ctrl + Y on Windows or Cmd + Y on Mac brings the change back. Redo only works if you haven't typed anything new since undoing — the moment you make a fresh edit, the redo history clears. That's the part most people get wrong.

Picture this: you delete a column, undo it, then start typing in another cell. Try Ctrl + Y now and nothing happens. The new edit overwrote the redo buffer. If you're testing a "what if" scenario, finish thinking before touching the keyboard again, or you'll lose your safety net.

Undo and redo on the Quick Access Toolbar

If your toolbar doesn't show these buttons, right-click the ribbon and choose Customize Quick Access Toolbar. Add Undo and Redo from the command list. You can pin them above or below the ribbon — your call. Some users like the buttons near the workbook tabs for one-click access during heavy editing sessions.

How many actions can Excel undo?

By default, Excel remembers your last 100 actions. That's plenty for most workflows, but if you've been working in a single workbook for hours without saving or closing, you can hit the ceiling. Once you exceed 100 steps, the oldest edit drops off the list and becomes unrecoverable.

Power users who want a deeper buffer can change the limit through the Windows registry. Open regedit, navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\[version]\Excel\Options, and add a DWORD called UndoHistory with a decimal value up to 100. Excel won't go higher than that on most builds, and bumping it up to the maximum eats memory — so don't expect 500 levels of undo no matter what you do. The cap is real.

Undo in Excel for the web

The browser version supports undo too. Press Ctrl + Z (or Cmd + Z on Mac) and Excel Online reverses the last edit. The undo button also appears in the Home tab on the ribbon. The history isn't as deep as the desktop version — you'll get fewer levels of rollback — but the basics work identically.

One quirk worth knowing: if you're collaborating in real time and someone else edits the workbook after you, your undo only reverses your changes. You can't undo their edits. The system tracks each user's history separately, which keeps collaborative sessions from descending into chaos.

Undo on Excel mobile (iOS and Android)

The mobile apps include undo, but you have to look for it. On iPhone or iPad, tap the curved arrow icon in the top toolbar — same on Android. There's no two-finger swipe gesture like you'd get in a notes app, and the undo depth is shallower than desktop. Mobile is fine for quick edits and reviewing data, but if you're doing serious work, save often. The mobile undo buffer can be flaky on long sessions.

What undo cannot reverse

Here's the trap: not every action in Excel is undoable. Some operations clear the undo history entirely the moment you do them. Once that happens, you can't roll back anything — not even edits from minutes ago. The big ones to watch:

• Saving the file. Hitting Ctrl + S doesn't wipe undo on its own in modern Excel, but closing the file does.
• Closing the workbook. All undo history dies when the file closes. Reopening won't restore it.
• Running a macro. VBA actions usually clear the undo stack. If you run a script that modifies cells, you can't undo what came before.
• Deleting a worksheet. Sheet deletion is permanent in older Excel versions. Newer builds let you undo it, but don't count on it.
• Filtering or sorting in some Power Query loads. External data refreshes and Power Query operations bypass the regular undo buffer.

If you're about to do something risky, save a copy first. Ctrl + S, then keep working — that way, even if undo fails, you have a backup file to fall back on.

Recovering from a closed workbook

You closed the file. You lost work. Now what? Excel's AutoRecover feature saves snapshots every ten minutes by default. Open Excel, go to File → Info → Manage Workbook → Recover Unsaved Workbooks. If AutoRecover caught your last edit, it'll be there. The interval can be changed in Options → Save — drop it to two or three minutes if you handle critical data.

Version history works too if you save to OneDrive or SharePoint. Right-click the file, choose Version History, and pick a previous save point. This isn't undo in the traditional sense, but it's the closest thing to a time machine when undo has failed you.

Common scenarios where undo saves you

You'll lean on undo most often during these moments:

• Wrong paste. You meant to paste values, but pasted formulas instead. Ctrl + Z, then Ctrl + Alt + V for paste special.
• Bad sort. Sorting a table without selecting all related columns can scramble your data. Undo immediately, then sort properly.
• Formula overwrite. You typed a number into a cell that held an important formula. Ctrl + Z brings the formula back.
• Accidental delete. Selected too many rows and hit delete. Undo restores everything, even the formatting.
• Conditional format gone wrong. Applied a rule that turned the whole sheet red. Undo reverses it cleanly.

Practice makes the shortcut stick

Reading about undo and using it under pressure are two different things. The best way to lock in the muscle memory is to practice deliberately — open a sample workbook, make changes, undo them, redo them, undo again, and trace the path. Combine that with the related skills like working with excel in spreadsheet hygiene workflows, and you'll move through Excel without fear of breaking anything you can't fix.

If your team is preparing for a certification or a new role, the broader topic of excel certification readiness pulls everything together — keyboard shortcuts, formula auditing, error handling, and recovery techniques. Undo is one piece, but it's the piece that buys you the freedom to experiment without consequences.

One final tip: if you're nervous about a big change, duplicate the worksheet first. Right-click the tab, choose Move or Copy, check the "Create a copy" box, and you've got a fallback that doesn't depend on the undo buffer at all. Belt and braces — that's how spreadsheet pros stay sane.