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

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.

Practice

1. What is the main purpose of the Track Changes feature in Excel?

easy

A. To automatically save the workbook every minute

B. To add notes or questions without changing data

C. To protect the workbook with a password

D. To see edits made by others in a shared workbook

Solution

1. Step 1: Understand the function of Track Changes

   Track Changes highlights edits made by different users in a shared Excel file.

2. Step 2: Compare with other features

   Comments add notes without changing data, so they are different from Track Changes.

3. Final Answer:

   To see edits made by others in a shared workbook -> Option D

4. Quick Check:

   Track Changes = See edits [OK]

Hint: Track Changes shows edits; Comments add notes [OK]

Common Mistakes:

• Confusing Track Changes with Comments
• Thinking Track Changes protects the file
• Assuming Track Changes autosaves the file

2. Which of the following is the correct way to insert a comment in Excel?

easy

A. Right-click a cell and select 'Insert Comment'

B. Press Ctrl + T to add a comment

C. Use the formula =COMMENT() in a cell

D. Double-click a cell and type a comment directly

Solution

1. Step 1: Recall how to add comments

   Right-clicking a cell and choosing 'Insert Comment' is the standard method.

2. Step 2: Check other options

   Ctrl + T is for tables, =COMMENT() is not a valid formula, and double-click edits cell content.

3. Final Answer:

   Right-click a cell and select 'Insert Comment' -> Option A

4. Quick Check:

   Insert Comment = Right-click menu [OK]

Hint: Right-click cell to add comment quickly [OK]

Common Mistakes:

• Using wrong shortcut keys
• Trying to add comments with formulas
• Typing comments directly in the cell

3. If you enable Track Changes and someone edits cell B2 from 10 to 15, what will you see in the worksheet?

medium

A. The cell B2 will show 10 and the change will be hidden

B. The cell B2 will show 15 with a colored border and a comment about the change

C. The cell B2 will be locked and uneditable

D. The cell B2 will show 15 with no indication of change

Solution

1. Step 1: Understand Track Changes behavior

   When Track Changes is on, edited cells show the new value with a colored border and a note about who changed it.

2. Step 2: Eliminate incorrect options

   The old value is replaced, cells are not locked automatically, and changes are not hidden or invisible.

3. Final Answer:

   The cell B2 will show 15 with a colored border and a comment about the change -> Option B

4. Quick Check:

   Track Changes = Highlight edits [OK]

Hint: Track Changes highlights edited cells with border and info [OK]

Common Mistakes:

• Thinking old value stays visible
• Assuming cells lock after edit
• Believing changes are invisible

4. You tried to enable Track Changes but the option is grayed out. What could be the reason?

medium

A. The workbook is not shared or saved as a shared workbook

B. You have comments in the workbook

C. The workbook is protected with a password

D. You are using Excel Online which does not support Track Changes

Solution

1. Step 1: Check workbook sharing status

   Track Changes requires the workbook to be shared; if not shared, the option is disabled.

2. Step 2: Review other options

   Comments do not disable Track Changes; protection or Excel Online may affect it but sharing is the main cause.

3. Final Answer:

   The workbook is not shared or saved as a shared workbook -> Option A

4. Quick Check:

   Track Changes needs shared workbook [OK]

Hint: Track Changes needs shared workbook enabled [OK]

Common Mistakes:

• Confusing comments with sharing
• Ignoring workbook protection effects
• Not knowing Excel Online limitations

5. You want to review all changes made in a shared workbook and accept or reject them. Which steps should you follow?

hard

A. Use the formula =ACCEPTCHANGES() in a new cell

B. Right-click any cell and select 'Accept Changes' directly

C. Go to Review tab, click Track Changes > Highlight Changes, then click Accept/Reject Changes

D. Save the workbook as a new file to accept all changes automatically

Solution

1. Step 1: Locate Track Changes review options

   In the Review tab, Track Changes menu lets you highlight and manage changes.

2. Step 2: Use Accept/Reject Changes feature

   You can accept or reject changes after highlighting them; no formula or right-click option exists for this.

3. Final Answer:

   Go to Review tab, click Track Changes > Highlight Changes, then click Accept/Reject Changes -> Option C

4. Quick Check:

   Review tab > Track Changes > Accept/Reject [OK]

Hint: Use Review tab Track Changes to accept or reject edits [OK]

Common Mistakes:

• Trying to accept changes via formulas
• Expecting right-click menu for accepting changes
• Thinking saving file accepts changes automatically