Track changes and comments in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of 'Track Changes' in Excel?

Track Changes helps you see what edits were made, who made them, and when. It is useful for reviewing and approving changes in shared workbooks.

beginner

How do you add a comment to a cell in Excel?

Right-click the cell and choose 'New Comment' or 'Insert Comment'. Then type your note. Comments help explain or give feedback without changing the cell's value.

beginner

What happens when you accept a change in Excel's Track Changes?

Accepting a change applies the edit permanently and removes it from the list of tracked changes.

intermediate

Can multiple people add comments and track changes in the same Excel file?

Yes, multiple users can add comments and track changes if the workbook is shared or saved on a shared location like OneDrive.

intermediate

Where can you find the list of all tracked changes in Excel?

You can view all tracked changes by going to the Review tab and clicking 'Track Changes' then 'Highlight Changes'. This shows edits made by users.

Which tab in Excel contains the 'Track Changes' feature?

A Review

B Home

C Insert

D Data

The 'Track Changes' feature is found under the Review tab in Excel.

What does a comment in Excel do?

A Adds a note or explanation to a cell

B Formats the cell background

C Deletes the cell content

D Changes the cell value

Comments add notes or explanations to cells without changing their values.

What happens when you reject a tracked change in Excel?

A The change is permanently applied

B The change is removed and original content stays

C The workbook is saved automatically

D The comment is deleted

Rejecting a change removes the edit and keeps the original content.

How can you see who made a change in a shared Excel workbook?

A By checking the cell color

B By opening the file properties

C Using Track Changes to highlight edits

D By sorting the data

Track Changes highlights edits and shows who made them.

Which of these is NOT true about comments in Excel?

A They appear as small indicators in cells

B They can be replied to in newer Excel versions

C They help explain data

D They change the cell's value

Comments do not change the cell's value; they only add notes.

Explain how to use Track Changes in Excel to review edits made by others.

Think about the steps from turning on tracking to finalizing edits.

Describe the difference between comments and Track Changes in Excel.

One is for notes, the other for edits.