Highlight changes as you work

Microsoft Excel marks revisions, including insertions and deletions, with a highlight color.

1. On the Tools menu, point to Track Changes, and then click Highlight Changes.

2. Make sure the Track changes while editing check box is selected. This check box shares the workbook and turns on change tracking.

3. Select the When check box, click Not yet reviewed, and then click OK.

4. If prompted, save the workbook.

5. Make the changes you want on the worksheet. Some changes, such as formatting, aren't marked.