To find recent cell edits in Microsoft Excel for Microsoft 365 on Windows, open the workbook saved in OneDrive or SharePoint and choose Review > Show Changes. To view or restore an earlier saved copy of the whole workbook, open File > Info > Version History. These are different tools: Show Changes lists supported cell edits, while Version History shows saved versions of the file.
What You’ll Need
- For Show Changes: a workbook saved to OneDrive or SharePoint, an internet connection, and a current version of Excel or Excel for the web. You may need permission to access the file.
- For Version History: a workbook stored in OneDrive or SharePoint, where earlier saved versions can be available. The number and age of versions depend on the service and your organization’s settings.
- For a local-only workbook: check whether a backup service, such as Windows File History or Time Machine on Mac, was set up before the edit. Excel does not automatically keep a complete edit log for every file saved only on your computer.
Step-by-Step
- Identify which history you need. If you want to know who changed a particular cell, when it changed, or what value it had before, start with Show Changes. If you need to compare or recover an earlier saved state of the entire workbook, use Version History. If you are unsure, check both: one may show details that the other does not.
For example, imagine a shared budget workbook where a total changed unexpectedly. Show Changes may identify the edited cell and its previous value. Version History can help you open a saved workbook from before the total changed, but it may not explain which individual edit caused the difference.
- Open the correct workbook and confirm where it is saved. In Excel for Windows, open the file and check its name and save location. A cloud file is usually in OneDrive or a SharePoint library; a path such as
C:\Users\Name\Documentsis a local folder. If the file is local, save a copy to OneDrive or SharePoint before collaborating in the future. Uploading it now will not recreate a history of edits made before it was uploaded. - Open the cell-level change list. In the Windows desktop app, select Review > Show Changes. Excel opens a Changes pane, usually along the right side. In Excel for the web, open the workbook in your browser and choose Review > Show Changes there as well. If the command is missing or unavailable, check that you are signed in, online, and working with a supported cloud-stored workbook.
- Find the edit in the Changes pane. Review the entries, which can include the editor’s name, the cell or range, the time of the change, and the earlier value for supported edits. Select an entry to locate or highlight the affected cell in the sheet. If the pane has a search or filter control in your version, use it to narrow the list; otherwise, scan the entries and verify the cell reference in the worksheet.
- Check the value and the context before acting. Select the affected cell and examine its current value, formula bar, and nearby rows or columns. A changed formula may affect many results even if only one cell was edited. If the entry provides a previous value, compare it with the current value and ask the workbook owner or editor if the reason for the change is unclear. Show Changes is useful for review, but it is not a substitute for understanding how the workbook is used.
- Open Version History for earlier saved copies. In Excel for Windows, choose File > Info > Version History. You can also select the workbook name in the title bar and look for Version History. In Excel for the web, select the workbook name at the top and choose Version history; menu wording can vary slightly by account or interface. A list or pane of saved versions should appear.
- Inspect a version before restoring it. Select a dated version to open or preview it. Check the timestamp and compare the relevant sheets, cells, formulas, and formatting with the current workbook. If you need to keep both states, first make a separate copy of the current file. When you are sure you want the older state to become current, use the available Restore command. Restoring changes the current workbook; it is not the same as simply viewing a version. Reopen the current file afterward and confirm the result.
- Close the pane when you are done. Close the Changes or Version History pane using its close control. If you made no edits, there is nothing to save. If you restored a version or made other changes, confirm that the workbook has saved and that the cloud sync indicator is finished before closing it or sharing it with others.
Common Mistakes
Looking for a complete audit trail in Show Changes. The pane is designed to show supported changes to cell values and formulas, not every action taken in a workbook. Formatting changes, comments, charts, moving objects, and other workbook actions may not appear as cell edits. Do not assume that an empty or incomplete list proves that nobody changed the file.
Confusing a version with a cell-by-cell log. Version History generally gives you saved snapshots of the workbook. It can help you recover a previous state, but it may not say which person changed a specific value or show every action between two snapshots. Use Show Changes for available cell-level details and Version History for saved file states.
Expecting history for a file that was always local. Excel does not create cloud Version History for an ordinary file stored only on your computer. Saving a local workbook to OneDrive today does not backdate its history. Check device backups if they were enabled, but do not expect an unconfigured backup system to contain an earlier copy.
Restoring without preserving the current version. A restore can replace the current state with an older one. Before doing it, download or make a copy of the current workbook if its latest data may still be needed. Also make sure you selected the intended date; similar timestamps can be easy to confuse in a busy shared workbook.
Treating comments as edit history. Comments and threaded conversations can explain a change, but they do not necessarily record the original value or every edit. A note in a comment is not proof that the cell still contains the value discussed.
Tips
- Use descriptive file names and folders. A clear project name makes it easier to identify the right workbook and avoid checking the history of an outdated copy.
- Use Show Changes soon after noticing an issue. The feature retains a limited period of change information, commonly up to 60 days, rather than an indefinite audit record. Retention and availability can depend on the file and Microsoft 365 environment.
- Ask collaborators to use supported current Excel versions. Shared editing works best when everyone is signed in and working with a compatible version. If someone edits through an older or unsupported workflow, the change details may be incomplete or collaboration behavior may differ.
- Keep a separate copy before significant recovery work. Use Save a Copy or download the workbook before restoring a version, especially when multiple people are editing. This gives you a way to inspect the current state later without relying on memory.
- Record important decisions separately. For regulated, financial, or operational records, do not rely on Excel’s change pane as the organization’s sole audit log. Follow your organization’s retention and recordkeeping process.
- Use filters and cell references carefully. If several edits have similar times or values, confirm the worksheet name and cell address. A change to one sheet can look similar to an entry on another sheet, particularly in workbooks with repeated layouts.
Troubleshooting
Show Changes is greyed out or missing: confirm you are signed in to Microsoft 365, connected to the internet, and have access to the workbook. Check whether the file is saved in OneDrive or SharePoint rather than only on your computer. Update Excel if your organization allows it, or open the workbook in Excel for the web and check Review > Show Changes. Some workbook formats or features may not support the same collaboration behavior, so try a supported modern workbook format on a copy if appropriate.
The pane opens but does not show the edit: verify that you have the right file and worksheet, then check the cell itself and the workbook’s Version History. Show Changes is not a permanent, exhaustive log and may not capture every kind of action. A formatting-only change or an edit made in an incompatible workflow may not appear as the entry you expect. If the change matters, ask the person who edited the workbook and compare available saved versions.
Version History is empty: make sure the workbook is stored in OneDrive or SharePoint and that you are signed in to the account or organization that owns it. A local file, a newly uploaded file, or a file with retention settings that limit versions may not have the older copy you need. If the file is in a work or school SharePoint site, ask the site owner or administrator whether versioning is enabled and whether older versions are retained.
You cannot restore a version: you may have view-only permission, or your organization may restrict restoring or deleting versions. Ask the file owner for edit access or for help recovering the copy. If you can open an older version but cannot restore it, save a separate copy if that option is available, then ask the owner before replacing the shared workbook.
The workbook is stored only on your computer: check Windows File Explorer by right-clicking the file, choosing Properties, and looking for a Previous Versions tab. This only helps when File History or another backup feature had retained a copy. On Mac, check Time Machine if it was set up and had backed up the folder. If no backup exists, Excel may not be able to recover an earlier state.
Frequently Asked Questions
Can I see who changed a cell in Excel?
Often, yes. For a supported workbook saved in OneDrive or SharePoint, open Review > Show Changes and look for the editor name, cell, time, and previous value. The details are not guaranteed for every type of workbook action.
How far back does Excel Show Changes go?
Show Changes keeps change information for a limited period, commonly up to 60 days. It is not a permanent audit log, and availability can depend on the workbook and Microsoft 365 environment. Use Version History or an approved recordkeeping system for longer-term needs.
Can I see edit history in Excel without OneDrive?
Excel does not provide the same cloud-based Show Changes and Version History features for a file kept only on a local drive. You may be able to recover a backup using Windows File History, Time Machine on Mac, or another backup service if it was already configured.
Does Version History show every cell edit?
No. It shows saved versions of the workbook, not necessarily a detailed list of each action between versions. Use Show Changes for supported cell-level edits, and compare versions when you need to inspect broader changes.
Can I recover an earlier version without losing the current one?
Make a separate copy of the current workbook first. Then open the version you want to inspect and use Restore only when you are ready to make that older state current. Your access permissions and the service’s version settings can affect which options are available.
Is Track Changes the same as Show Changes?
No. Track Changes refers to a legacy shared-workbook feature, while Show Changes is the current Microsoft 365 tool for reviewing supported edits in a shared cloud workbook. If you are following instructions for an older Excel release, the menu and behavior may differ.
Related
- How to Enable Paste Special in Excel
- How to Enable Freeze Panes in Excel
- Forecast Sheet in Excel 2007: What You Can Do Instead
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Use Goal Seek on Multiple Cells in Excel at Once?No. In Microsoft Excel for Microsoft 365 on Windows, Goal Seek changes one input cell to make the…
- Excel Cut Shortcut: How to Move Cells with Ctrl+XIn Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+X to cut it;…
- Excel Shortcut to Select the Rest of a Column DownIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+Down Arrow to extend a selection downward from the active…
- Free Savings Tracker Google Sheets: Set Up a Simple SheetYes. You can make a free savings tracker in Google Sheets by starting with a blank spreadsheet, recording…
- SUMIF with OR in Google Sheets: Formulas That WorkTo use SUMIF with OR logic in Google Sheets, add the results of separate SUMIF formulas, or use…
- Google Sheets IF Syntax: Examples and Common ErrorsIn Google Sheets, IF syntax is =IF(condition, value_if_true, value_if_false): it checks a condition and returns one result when…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.