How to Use Track Changes and Comments in Excel (Khmer)

Hello everyone! Today I show you how to use Track Changes and Comments in Excel step by step with simple explanations and video guide in Khmer language.

When multiple people work on same Excel file, Track Changes and Comments help you see who changed data, what value was edited, and leave feedback easily!

Method 1: Insert Comments vs Notes in Excel

In modern Excel, there are two types of annotations:

1. Threaded Comment (For Team Discussion)

Use Comment when you want to chat or discuss with team members directly inside cell.

• Shortcut: Ctrl + Alt + M (or Right-click cell ➔ select New Comment).
• You can @mention person name and team member can reply to your comment!
• Cell will show purple marker in top-right corner.

2. Classic Note (For Simple Reminder)

Use Note when you just want to put small reminder text for yourself.

• Shortcut: Shift + F2 (or Right-click cell ➔ select New Note).
• Cell will show small red triangle in top-right corner.

Method 2: Enable Track Changes in Excel

Track Changes records every edit made to cells (shows author name, date, time, old value, and new value).

Step by Step:

1. Go to Review tab on ribbon menu.
2. Click Track Changes ➔ select Highlight Changes....
3. Check box Track changes while editing. This also shares your workbook.
4. Check When: All and Who: Everyone.
5. Make sure Highlight changes on screen is checked.
6. Click OK.

Now when anyone changes cell data, Excel draws small blue border around cell and shows exact edit history when you hover mouse over it!

Method 3: How to Accept or Reject Changes

After team finish editing file, manager can review and accept or reject each change:

1. Go to Review tab ➔ click Track Changes ➔ select Accept/Reject Changes.
2. Click OK on popup message box.
3. Excel will jump cell by cell showing change history:
   • Click Accept to keep new value.
   • Click Reject to revert back to original old value.
   • Click Accept All or Reject All to apply for whole workbook.

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to use Track Changes and Comments in Excel:

💡 Quick Tip:

• Comment vs Note Shortcut: Press Shift + F2 to create classic yellow note instantly! Press Ctrl + Alt + M to start threaded comment thread.
• Track Changes Button Missing?: If you use Excel 365 and cannot find Track Changes button, go to File ➔ Options ➔ Customize Ribbon ➔ under Choose commands from, select Commands Not in the Ribbon ➔ add Track Changes (Legacy) to your Review tab!
• Excel for Web / OneDrive: If file saved on OneDrive/SharePoint, go to Review tab ➔ click Show Changes button to view complete visual audit log of all edits!

📚 Related Resources

• How to Set Header and Footer in Excel
• How to Split Phone Number with Formula in Excel
• How to Split Decimal Number into Two Parts in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know