How to track changes in a spreadsheet
PURPOSE
Tracking changes helps teams understand who changed what and when.
METHODS
Use version history, comments, change tracking, protected ranges, or a manual change log depending on the spreadsheet tool.
BEST PRACTICES
Use comments for questions, avoid overwriting others' work without explanation, and save major versions before big edits.
REVIEW
Check version history when data changes unexpectedly.
LIMITATION
Not all spreadsheet formats preserve detailed change history.