Can You Track Changes in Excel

What this does

Excel's classic Track Changes is not the Word feature people expect, and Microsoft has retired it from the ribbon. It only ever worked by turning the file into a Shared Workbook, which disabled tables, conditional formatting, charts and much else, and it stored the history inside the file. What replaced it is Version History: a workbook stored on OneDrive or SharePoint keeps timestamped versions you can open, compare and restore, with the author recorded for each. If you still need the legacy behaviour it exists, but it must be added back manually via File ▸ Options ▸ Quick Access Toolbar ▸ All Commands ▸ Track Changes (Legacy). Where you need a real audit trail of who changed which cell, neither feature is the right answer — a change-log sheet, or a database, is. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “can you track changes in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

A budget on SharePoint edited by four people. File ▸ Info ▸ Version History shows an entry per save session with the editor's name. Opening the version from Tuesday afternoon shows the numbers before the forecast revision, and Restore puts them back as the current version — leaving the intervening versions intact. The question is nearly always "what did this look like before, and who changed it" — and on a cloud-stored workbook Version History answers that without the costs the legacy feature imposes. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “can you track changes in excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

Common mistakes

• Expecting Word-style coloured markup in the cells — Excel never showed changes that way.
• Turning on legacy Track Changes and losing tables, slicers and conditional formatting to Shared Workbook mode.
• Relying on Version History for a local file, where nothing is being versioned at all.
• Treating the history as an audit log: it records saves, not individual cell edits, and it is not tamper-proof.
• Assuming AutoSave and Version History are the same thing — AutoSave writes, Version History is what lets you go back.

Frequently asked questions