When multiple people edit the same Excel workbook, it’s critical to know who changed what, when they changed it, and why. Excel’s Track Changes feature provides complete visibility into all modifications, enabling you to review, accept, or reject edits with confidence. This is essential for maintaining data integrity, ensuring compliance, and managing collaborative projects effectively.
This comprehensive guide covers everything you need to know about tracking changes in Excel, from enabling the feature to accepting or rejecting individual modifications.
Why Track Changes in Excel?
Track Changes is essential for collaborative work and data governance:
- Audit trail: Document exactly who changed what and when for compliance
- Data integrity: Prevent accidental overwrites and maintain data quality
- Change review: Decide which modifications to keep and which to discard
- Accountability: Know who is responsible for each change
- Error recovery: Revert unwanted changes easily
- Collaboration efficiency: Streamline the review process for team edits
1. Understanding Track Changes vs. Show Changes
Track Changes (Legacy Feature)
The traditional Track Changes feature requires sharing the workbook. Key characteristics:
- Works on locally stored Excel files
- Requires workbook to be explicitly shared
- Highlights changes with colored borders and triangular indicators
- Limited to one person editing at a time (turns to offline when another user edits)
- Change history kept for configurable period (default: 30 days)
Show Changes (Modern Feature – Excel 365)
The newer Show Changes feature enables real-time collaborative editing:
- Works with OneDrive, SharePoint, or Excel Online files
- Enables true co-authoring with simultaneous editing
- Shows changes in a separate pane with filtering options
- Retains change history for up to 60 days
- Works across Windows, Mac, iPad, iOS, and Android
- No shared workbook mode required
2. Enabling Track Changes (Legacy Method)
Step 1: Locate the Track Changes Button
In newer Excel versions, Track Changes is hidden by default. To unhide it:
- Go to the Review tab on the ribbon
- Look for the Track Changes button in the Changes group
- If not visible, click the Track Changes dropdown arrow
- If still not visible, add it to your Quick Access Toolbar:
- Click the dropdown arrow at the end of the Quick Access Toolbar (top-left)
- Select More Commands
- In the dropdown, select All Commands
- Scroll and find Track Changes (Legacy)
- Click Add > to move it to the right column
- Click OK
Step 2: Enable Track Changes Feature
- Go to Review > Track Changes dropdown
- Select Highlight Changes…
- In the Highlight Changes dialog box:
- Check “Track changes while editing” (this also shares the workbook)
- Select “When” option to choose tracking scope:
- All: Track all changes from workbook creation
- Since I last saved: Track only changes since last save
- Not yet reviewed: Track unreviewed changes
- Since date: Track from a specific date forward
- Optionally select “Who” to filter specific users
- Optionally specify “Where” to track only certain cells or ranges
- Check “Highlight changes on screen” to see visual indicators
- Optionally check “List changes on a new sheet” for a separate history
- Click OK
Step 3: Save the Workbook
When you enable Track Changes, Excel automatically shares the workbook. A dialog appears asking to save—click OK to proceed. The title bar will show “[Shared]” indicating shared mode is active.
3. Understanding Change Indicators
Visual Markers on Changed Cells
When Track Changes is active, modified cells display:
- Colored border: Each user’s changes appear in a unique color
- Small triangle: Appears in the top-left corner of changed cells
- Cell comment: Hover over the triangle to see change details including:
- Who made the change
- When the change occurred
- What was changed (old value vs. new value)
Example Change Indicator:
| Element | Displays |
|---|---|
| Cell Border | Blue (or assigned user color) |
| Triangle | Top-left corner of cell |
| Hover Tooltip | Sarah Johnson changed this cell on 2/3/2026 4:30 PM Old Value: $45,000 New Value: $50,000 |
4. Using Show Changes (Modern Excel 365 Method)
View All Changes in Your Workbook
- Open your workbook stored on OneDrive or SharePoint
- Go to the Review tab
- Click Show Changes
- A pane opens on the right side showing:
- Most recent changes first
- Who made each change (user name)
- When the change occurred (timestamp)
- What was changed (cell location and description)
- Old and new values for quick reference
Filter Changes by Range or Sheet
- Select a specific cell, range, or entire sheet
- Right-click and select Show Changes
- The pane displays only changes to that selection
- This is useful for reviewing changes in specific areas only
Narrow Down Changes with Filters
- In the Show Changes pane, click the Filter icon
- Select Range or Sheet
- For Range: Enter specific cell reference (e.g., A1:C10)
- For Sheet: Select sheet from dropdown
- Click the arrow icon to confirm
- View displays only filtered changes
5. Reviewing and Accepting Changes
Step-by-Step: Accept or Reject Changes
- Go to Review > Track Changes dropdown
- Select Accept/Reject Changes
- A dialog appears asking to save the workbook—click OK
- In the Select Changes to Accept or Reject dialog:
- When: Select filter option
- Not yet reviewed: Shows only unreviewed changes (recommended)
- Since date: Choose a specific date
- Who: Choose which user’s changes to review
- Everyone: All changes by all users
- Everyone but me: Changes made by others
- Specific user: Select from dropdown
- Where: Leave blank for all cells or specify range
- Click OK
- When: Select filter option
- Excel displays the first unreviewed change in a dialog showing:
- Cell location
- Old value
- New value
- User who made the change
- Timestamp
- Choose your action:
- Accept: Keep the new value
- Reject: Revert to the original value
- Accept All: Approve all remaining changes
- Reject All: Discard all remaining changes
- Excel moves to the next change and repeats until all changes are reviewed
6. Creating a History Sheet
Automatically Generate Change History
Excel can create a separate sheet documenting all changes:
- Go to Review > Track Changes > Highlight Changes
- In the Highlight Changes dialog, check “List changes on a new sheet”
- Click OK
- A new sheet called “History” is created with columns:
- Sheet name where change occurred
- Cell address
- Type of change (deleted, inserted, changed)
- Old value
- New value
- Date and time of change
- User who made the change
- Action taken (accepted, rejected, or pending)
- This history sheet updates automatically with new changes
- You can filter, sort, and print this sheet for audit purposes
7. Managing Change History Duration
Set How Long to Keep Change Records
By default, Excel keeps change history for 30 days. To modify this:
- Go to Review > Track Changes > Highlight Changes
- Click Advanced… button (if available) or go to Review > Share Workbook
- In the Share Workbook dialog, go to the Advanced tab
- Find “Keep change history for” setting
- Enter the number of days to keep history (maximum 32,767 days)
- Click OK
Note: Once the retention period expires, changes older than the specified date are automatically deleted and cannot be recovered.
8. Turning Off Track Changes
Disable Change Tracking
- Go to Review > Track Changes > Highlight Changes
- In the dialog box, uncheck “Track changes while editing”
- Click OK
- A dialog appears asking if you want to accept all changes before stopping tracking—choose appropriately
- Click Save to finalize the decision
- The “[Shared]” indicator disappears from the title bar
Important: Once you disable Track Changes and accept all changes, the change history is removed and cannot be recovered.
9. Limitations and Considerations
What Track Changes Does NOT Capture
Track Changes in Excel does not record:
- Formatting changes: Font, color, bold, italic, borders (values only)
- Row/column operations: Inserting or deleting rows/columns
- Chart changes: Modifications to charts or graphics
- Formula changes to result: Formula modifications appear as value changes
- Sheet deletions: Entire sheet removal
Shared Workbook Limitations
When Track Changes is enabled (shared workbook mode):
- Only one user can edit at a time (offline mode for others)
- Some features are unavailable in shared mode:
- Merge cells
- Create PivotTables
- Use data validation (modify existing)
- Create or modify charts
- Insert pictures or objects
- File size may increase significantly due to change history storage
10. Track Changes Best Practices
Before Enabling Track Changes
- Save first: Create a clean version before starting to track
- Close conflicting files: Ensure no other copies are open
- Notify users: Let team members know tracking is active
- Set expectations: Define review and approval process
During Collaborative Editing
- Add meaningful notes: Use the Comments feature alongside Track Changes to explain why changes were made
- Review frequently: Accept or reject changes regularly rather than batching
- Communicate changes: Notify others which changes you’ve accepted/rejected
- Keep backups: Save regular copies in case of merge conflicts
When Finalizing Changes
- Review all changes: Use the History sheet to verify completeness
- Document decisions: Note which changes were rejected and why
- Save final version: Create a clean final copy with Track Changes disabled
- Archive change history: Save or print the History sheet for records
11. Troubleshooting Common Issues
Problem: “Track Changes Not Visible”
Solutions:
- Go to Review > Track Changes > Highlight Changes
- Ensure “Highlight changes on screen” is checked
- Verify “When” is set to display relevant changes
- Check “Where” isn’t filtering out your cells
Problem: “Can’t Enable Track Changes”
Solutions:
- File must be in .xlsx format (not .xls)
- Disable Protected Sheets first (if protected)
- Close all other copies of the workbook
- Ensure you have Write permissions on the file
Problem: “Can’t Accept/Reject Changes”
Solutions:
- Save the workbook first (dialog will appear)
- Ensure you’re the designated reviewer with permissions
- Check if changes are already reviewed (filter to “Not yet reviewed”)
- Verify shared workbook mode is active
Problem: “Multiple Changes to Same Cell”
Handling:
If a cell has multiple changes by different users:
- The Accept/Reject dialog shows each change sequentially
- Choose to accept or reject each individual change
- You can accept some changes and reject others for the same cell
- The final cell value reflects your accumulated decisions
12. Comparison: Track Changes vs. Show Changes
| Feature | Track Changes (Legacy) | Show Changes (Excel 365) |
|---|---|---|
| Storage Location | Local file | OneDrive/SharePoint |
| Simultaneous Editing | No (offline mode) | Yes (true co-authoring) |
| Change History Duration | 30 days (configurable) | 60 days |
| Visual Indicators | Cell borders and triangles | Side pane with filtering |
| Filtering Options | Basic (when, who, where) | Advanced (range, sheet, date) |
| Mobile Support | No | Yes (iOS, Android) |
| Limitations | Many (PivotTables, charts, etc.) | None (full feature access) |
The Bottom Line
Excel’s Track Changes feature is essential for managing collaborative spreadsheet work and maintaining data integrity. Whether you use the legacy Track Changes method for local files or the modern Show Changes feature for cloud-based collaboration, these tools enable you to:
- Document all modifications for audit trails
- Review changes before finalizing data
- Accept or reject modifications with confidence
- Maintain complete change history for compliance
- Streamline collaborative workflows
Choose the method that best fits your workflow: Track Changes for traditional local file sharing, or Show Changes for modern cloud-based collaboration with unrestricted feature access.
