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:

1. Go to the Review tab on the ribbon
2. Look for the Track Changes button in the Changes group
3. If not visible, click the Track Changes dropdown arrow
4. 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

1. Go to Review > Track Changes dropdown
2. Select Highlight Changes…
3. 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:

4. Using Show Changes (Modern Excel 365 Method)

View All Changes in Your Workbook

1. Open your workbook stored on OneDrive or SharePoint
2. Go to the Review tab
3. Click Show Changes
4. 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

1. Select a specific cell, range, or entire sheet
2. Right-click and select Show Changes
3. The pane displays only changes to that selection
4. This is useful for reviewing changes in specific areas only

Narrow Down Changes with Filters

1. In the Show Changes pane, click the Filter icon
2. Select Range or Sheet
3. For Range: Enter specific cell reference (e.g., A1:C10)
4. For Sheet: Select sheet from dropdown
5. Click the arrow icon to confirm
6. View displays only filtered changes

5. Reviewing and Accepting Changes

Step-by-Step: Accept or Reject Changes

1. Go to Review > Track Changes dropdown
2. Select Accept/Reject Changes
3. A dialog appears asking to save the workbook—click OK
4. 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
5. Excel displays the first unreviewed change in a dialog showing:
   • Cell location
   • Old value
   • New value
   • User who made the change
   • Timestamp
6. 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
7. 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:

1. Go to Review > Track Changes > Highlight Changes
2. In the Highlight Changes dialog, check “List changes on a new sheet”
3. Click OK
4. 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)
5. This history sheet updates automatically with new changes
6. 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:

1. Go to Review > Track Changes > Highlight Changes
2. Click Advanced… button (if available) or go to Review > Share Workbook
3. In the Share Workbook dialog, go to the Advanced tab
4. Find “Keep change history for” setting
5. Enter the number of days to keep history (maximum 32,767 days)
6. 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

1. Go to Review > Track Changes > Highlight Changes
2. In the dialog box, uncheck “Track changes while editing”
3. Click OK
4. A dialog appears asking if you want to accept all changes before stopping tracking—choose appropriately
5. Click Save to finalize the decision
6. 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:

1. The Accept/Reject dialog shows each change sequentially
2. Choose to accept or reject each individual change
3. You can accept some changes and reject others for the same cell
4. The final cell value reflects your accumulated decisions

12. Comparison: Track Changes vs. Show Changes

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.

Related posts:

How to Find Outliers in Excel How to Standardize Data in Excel: Z-Score Normalization Guide How to Check for Prime Numbers in Excel