Cell edit history can help identify a direct change, but it does not record every cause of a displayed value. Use it alongside full version history and the formula’s dependencies.
Inspect the specific cell
On a computer, right-click the cell and choose Show edit history. Review the available entries and compare them with the time and value relevant to your investigation.
Confirm you are in the original file rather than a later copy. A copied workbook should not be assumed to contain the original’s complete editing history.
Recognize the documented omissions
Google lists changes that may not appear, including added or deleted rows and columns, formatting changes, and changes made by formulas. Changes before restoring a past version are also excluded from the current cell-history view.
If a formula’s result changed, inspect its source cells and external inputs. The absence of a direct edit entry does not prove the value never changed or that a particular person must have changed it manually.
Use broader evidence carefully
Open version history when you have editing permission and compare the relevant surrounding range. Note that versions can be grouped or merged, so timestamps and available details may not provide a complete event-by-event reconstruction.
Preserve evidence before restoring or otherwise altering the workbook. Do not attribute an action solely from an account name when shared credentials, automation, or indirect formula changes remain unresolved. For workflows needing a formal audit trail, use an authorized design with appropriate event records rather than relying exclusively on the visible cell history. Report what the available evidence shows and which changes remain outside that view.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.