Tracking Changes in Workbooks

Whenever you collaborate with a number of your colleagues in producing or editing a document, you should consider tracking the changes each user makes. When you turn on Track Changes, Excel 2007 highlights any changes made to the workbook in a color assigned to the user who made the changes. When you have a question about a change, you can quickly identify who made it and verify that it is correct.

Turn on Track Changes

  1. Click the Review tab.

  2. Click Track Changes.

  3. Click Highlight Changes.

  4. Select the Track Changes While Editing ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.