0
0
Excelspreadsheet~5 mins

Track changes and comments in Excel - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Tracking changes and adding comments helps you see what edits were made and share notes with others. This is useful when multiple people work on the same Excel file and you want to keep track of updates and feedback.
When you want to review edits made by your team on a shared Excel workbook.
When you need to add notes or questions about specific cells without changing the data.
When you want to approve or reject changes before finalizing the spreadsheet.
When collaborating remotely and you want to keep a record of who changed what and when.
When preparing a report and need feedback from others directly inside the file.
Steps
Step 1: Click
- Review tab on the Ribbon
The Review tools appear, showing options like Track Changes and New Comment
Step 2: Click
- Track Changes dropdown in the Review tab
A menu appears with options to Highlight Changes, Accept/Reject Changes, and List Changes on a New Sheet
Step 3: Select
- Highlight Changes
A dialog box opens where you can choose to track changes while editing and show changes on screen
Step 4: Check
- Track changes while editing checkbox in the Highlight Changes dialog
Excel starts tracking all edits made to the workbook
Step 5: Click
- OK button in the Highlight Changes dialog
Changes are now tracked and highlighted in the worksheet
Step 6: Select a cell
- any cell in the worksheet
The cell is active and ready for comment
Step 7: Click
- New Comment button in the Review tab
A comment box appears next to the selected cell where you can type your note
Step 8: Type
- the comment box
Your note is saved as a comment linked to the cell
Before vs After
Before
Workbook shows normal cells with no indication of edits or notes
After
Cells with changes are highlighted with a colored border and comments appear as small indicators
Settings Reference
Track changes while editing
📍 Review tab > Track Changes > Highlight Changes dialog
Turn on or off the tracking of all changes made to the workbook
Default: Unchecked
Highlight changes on screen
📍 Review tab > Track Changes > Highlight Changes dialog
Show the tracked changes visually in the worksheet
Default: Checked
List changes on a new sheet
📍 Review tab > Track Changes dropdown
Create a summary sheet listing all changes made
Default: Not applied
Comments visibility
📍 Review tab > Show Comments
Control whether comments are visible or hidden in the worksheet
Default: Hide Comments
Common Mistakes
Not enabling 'Track changes while editing' before making edits
Changes made before enabling tracking are not recorded and cannot be reviewed later
Always turn on 'Track changes while editing' before starting to edit the workbook
Deleting comments instead of resolving or replying to them
Important feedback or questions can be lost if comments are deleted prematurely
Use the reply or resolve options to keep track of comment discussions
Summary
Track changes lets you see who edited what and when in your Excel workbook.
Comments let you add notes or questions linked to specific cells.
Remember to enable tracking before editing to capture all changes.