If you need to know how to undo in Excel, first ask whether the workbook is still open. For a recent edit in the current session, press Ctrl+Z or select Undo. If you saved, closed, or reopened the file, do not keep pressing keys and hoping the old state returns. Preserve the current workbook, then look for version history or an earlier copy. The right method depends on what happened to the file, not on how serious the mistake feels.
First, protect the workbook you have now
Before reversing a change, use File > Save As to make a separate copy with a clear name, such as Budget-current-copy.xlsx. Save it somewhere you can find again. This step matters when several people edited a shared workbook or when useful entries arrived after the mistake. Restoring an older version can bring back the missing cells while also discarding those newer entries. A copy gives you room to compare rather than choose blindly.
Look at the workbook name in Excel’s title bar and the folder shown under File > Info. A similarly named file in Downloads, OneDrive, or a shared folder may not be the copy you intended to edit. If you opened an email attachment, your changes may sit in a downloaded copy rather than the team workbook. Note the file location and modified time before making another change. This simple check often explains why Undo seems to have failed: the user is examining a different file.
If the workbook is on a network share, ask collaborators to pause edits while you compare versions. Do not overwrite a team file with an older personal copy without checking which rows changed. On a local computer, you can copy the file to another healthy folder for inspection. Never use a missing-file recovery tool as the first answer when the workbook still exists and Excel merely shows the wrong values.
Use Undo while the edit is still in the current session
For a mistaken entry, formula, format, or deleted cell range, press Ctrl+Z once and inspect the result. Continue one action at a time until you reach the desired state. The curved-arrow Undo button near Excel’s upper-left corner serves the same purpose. If it offers a list, review the action names before selecting several together. You can use Ctrl+Y or Redo if you reversed one action too many. Microsoft explains the supported commands in its Undo and Redo guidance.
Do not use a long chain of Undo presses without checking your formulas and totals. Undo tracks actions, not your intention. Reversing a sort might also return the previous row order; reversing a paste might remove values that someone asked you to add. If only one cell is wrong, a known correct value from a record or an earlier version can be safer than rewinding many unrelated edits. Confirm the affected sheet name and selected range before pressing the shortcut.
A gray Undo control usually means Excel has no reversible action available in that editing context. Closing and reopening a workbook often removes the session history. Some operations and add-ins may also clear or limit it. Do not interpret a gray button as proof that your earlier content has vanished. It only tells you that this particular route cannot take you back. Move to a saved version or backup instead.
If Excel is still open but you cannot tell which action caused the change, inspect the formula bar and the status of any filters. A row may appear missing because a filter hides it, not because you deleted it. On the Data tab, clear the relevant filter and search for a distinctive value. When the row returns, you have solved a visibility problem without reverting useful work.
Choose a recovery path based on what you saved
The table below is a decision aid, not a sequence to run from top to bottom. Start with the event that matches your workbook. Each branch has a different source of evidence.
| What happened | Best first place to look | Important limit |
|---|---|---|
| The workbook remains open after a recent edit | Undo, then inspect the affected cells | Undo may remove later useful actions |
| A cloud workbook was saved with the wrong values | Version History | Restoring a version can replace newer work |
| Excel closed before a new workbook was saved | Recover Unsaved Workbooks | An AutoRecover copy may not exist |
| The local workbook file itself was deleted | Recycle Bin, backup, then file recovery | Recovery software cannot undo edits inside an existing workbook |
If you are unsure whether the wrong action was a cell edit or deletion of the whole workbook, search File Explorer for the filename and extension. Then check the Recycle Bin. Finding the file changes the task: you need a prior version of its contents, not a deleted-file scan. If it is absent, see the more focused instructions for recovering a deleted Excel file.
Recover an earlier saved version without erasing later work
For a workbook stored in OneDrive or SharePoint, open the correct file and look for Version History near its name or under File > Info. The exact menu can vary by Excel version and account. Open an earlier entry to inspect its date, author, and contents. Compare the damaged sheet with your current copy before selecting Restore. If the old entry has the missing numbers but lacks later work, copy only the needed cells into a separate workbook when possible.
Version History is not a universal history of every local spreadsheet. It depends on the storage service and the way the file was saved. If you do not see it, do not invent a missing menu or assume the workbook is unrecoverable. Check whether a synced copy exists in the expected account, ask the file owner about shared versions, and inspect your organization’s backup system. A local backup can be more useful than an older cloud version when synchronization already propagated the mistake.
Windows Previous Versions may show a copy when File History or another backup mechanism was enabled earlier. In File Explorer, right-click the workbook or its parent folder and open Properties > Previous Versions. Use Open to inspect a candidate before choosing Restore. Save the useful copy somewhere else first. The detailed comparison with cloud versions belongs in our earlier Excel version article; here the main decision is whether an earlier copy actually contains the change you want.
After bringing back an older version, check formulas as well as visible values. A formula can refer to a sheet that changed later, and a restored workbook may contain links to another file. Recalculate and compare a few known totals with a trusted source. If the workbook is used for payments, reports, or inventory, ask the owner to approve the replacement rather than assuming an older timestamp means a correct result.
If Excel closed unexpectedly, look for an unsaved copy
When Excel closes before you save a new workbook, reopen Excel and check whether Document Recovery offers an available version. If no pane appears, open File > Info > Manage Workbook > Recover Unsaved Workbooks. Open each plausible copy and inspect the sheet names and recent entries. Save a useful candidate under a new filename; do not overwrite your preserved current copy. The list depends on AutoRecover settings and whether Excel created a recoverable file, so an empty list is possible.
A workbook that was saved earlier but changed afterward needs a slightly different check. Under File > Info, Manage Workbook may show a version labeled as one created when Excel closed without saving. Open it and compare the affected area. If Excel shows a Restore button, pause before using it, because it may replace the saved version. Save a separate copy or copy the needed sheet first. Microsoft describes these distinct cases in its Office recovery documentation, but the common principle is simple: inspect before replacing.
For a workbook that opens but behaves oddly, do not confuse AutoRecover with file repair. An unreadable workbook may need a protected copy and an Open and Repair attempt. An absent workbook needs a search, backup, or file-recovery path. Those are different problems, even when both appear after an Excel crash.
When the whole local workbook disappeared
Drecov helps only in a narrower branch of this problem: the original Excel file was deleted, a folder vanished, or a stable local volume no longer shows the workbook. It does not restore an earlier cell value inside a file that remains intact. On a Windows PC, Drecov’s read-only recovery mode can look for lost documents at their original storage location. Quick Scan offers a first pass, and Deep Scan is an option when the file is not found and the source remains stable. You can narrow results by filename, path, or file type, preview supported files, and save selected output to another healthy location. Drecov cannot repair physical damage or guarantee recovery after overwriting.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
Stop writing to the location that held the missing workbook. Do not install recovery software on that same partition. Prepare another healthy drive for the output. If the source disconnects, clicks, or reports repeated severe read errors, stop direct scanning and consider imaging or professional help. A scan is not a repair operation, and repeated scans on unstable media can worsen the situation.
Step 1: Select the original workbook location
Open Drecov and choose the Windows volume or original folder area where the missing .xlsx or .xls file lived. Use the relevant file-recovery mode rather than selecting a convenient but unrelated drive. If you last saw the workbook in a synced folder, determine which local path held the file and check the cloud service’s version and trash features first. A cloud-only file with no local copy is not a target for a local scan.
Step 2: Run Quick Scan, then decide whether Deep Scan is needed
Run Quick Scan and look for the workbook by name, former folder, and document type. If it is absent and the device is stable, use Deep Scan. Do not keep repeating scans when the device becomes unreliable. A candidate with the right filename is not necessarily the right version; its size and date can help you choose what to preview.
Step 3: Preview, recover elsewhere, and verify
Preview representative supported results. A successful preview is useful evidence, but it does not prove that every worksheet, formula, or linked object will work. Recover promising files to the healthy destination you prepared, never back to the original location. If the result is not where you expected, check the Drecov folder or Recovery folder. Open a copy in Excel, inspect the needed sheet, test formulas, and compare key values before you resume ordinary use.
If the file is still present and you only need older cells, return to Version History or your backup instead. For a broader explanation of recovery methods and their limits, see the file recovery overview. Avoid saving experimental repairs over the only copy you have.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
Three checks before you call the problem solved
First, confirm that you are viewing the correct workbook and sheet. The title, folder, account, and modified time should match the file you intended to fix. Second, verify the actual data. Inspect the changed cells, totals, formulas, and any linked sheets. Third, preserve the repaired or recovered workbook under a new filename. Keep the untouched version until another person or a later work session confirms that nothing important disappeared.
For ongoing protection, store important workbooks where version history or regular backups are available. AutoRecover and AutoSave can reduce loss in some situations, but neither replaces a separate backup or a quick check after major edits. If the file supports a business process, agree on who can restore older versions and how collaborators will review the result. That habit prevents a successful rollback from becoming the next data-loss event.
Conclusion
To undo in Excel, start with the method that matches the file’s state: Undo for an open session, Version History or backup for a saved change, and unsaved-workbook recovery after a crash. Preserve the current copy before restoring an older one. When the entire local workbook has vanished, Drecov can search the original stable Windows location and recover a usable candidate to another drive. Verify its sheets and formulas before replacing the working file.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
