Ctrl+Z is the most reliable safety net in Excel. But there are pitfalls: Undo is unavailable after saving, and repeatedly pressing it can take you further back than you intended. Know the limits, then use it wisely.
Shortcuts you will master in this article
Ctrl + Z / Ctrl + Y
If you accidentally delete a row in a summary table and frantically press Ctrl+Z repeatedly, you may end up reversing other recent changes as well. The classic result: 'I've gone too far back' or 'I don't know how far I've undone.'
Also, once you save a file with Ctrl+S, you can no longer undo past that save point. Saving regularly is a good habit, but for significant changes, taking a backup beforehand is the safest approach.
Using Redo alongside Undo lets you recover from over-undoing — not just fix mistakes.
Ctrl + ZEach press takes you one state further back. Use it immediately after an accidental entry or deletion.
Tip: You can press it multiple times in succession to undo a series of actions, as long as you haven't saved.
Ctrl + YIf you've gone back too far with Ctrl+Z, use Ctrl+Y to move one step forward.
Tip: As soon as you realize you've over-undone, try Ctrl+Y immediately.
Ctrl + Z (multiple times)By default, Excel stores up to 100 undo steps. However, saving resets the history to that point as the new baseline.
Tip: You can adjust the history limit in Excel Options, but increasing it affects memory usage.
F12Using F12 to save a backup copy before a significant change protects you in situations where Undo can't reach.
Tip: Naming the file something like 'original_before_changes' makes it easy to find later.
Excel Shortcut Practice
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Visit each shortcut detail page to see key positions and usage tips.
A. Up to 100 times by default. You can change this in Excel Options, but increasing the limit may slow down performance.
A. Saving with Ctrl+S can reset the Undo history. Use F12 to save under a new name before making changes you may want to reverse.
A. Yes. Deleting a sheet, certain macro operations, and some workbook protection settings cannot be undone.
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →