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 Changes → Highlight 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
Post a Comment