97. Tracking changes in a workbook

Tracking Changes in a Workbook

**Tracking Changes** in Excel allows you to monitor edits made to a workbook. This is especially useful for collaborative work, as it highlights who made changes, when the changes were made, and what the changes were.

Steps to Enable and Use Track Changes

  • Step 1: Go to the Review tab and select Track ChangesHighlight Changes.
  • Step 2: Check the box for "Track changes while editing" and specify how you want changes to be tracked.
  • Step 3: Save the workbook as a shared workbook if prompted.
  • Step 4: Review the changes highlighted in the workbook.

Interactive Example: Tracking Changes

Item Stock Price
Laptop 50 1200
Mouse 200 25
Keyboard 100 45

No changes have been tracked yet. Edit the table above and click "Track Changes" to view the change log.

This example simulates how to track changes in a workbook by logging edits made to the table above.

Comments