Excel 2010 Bible

Part IV: Using Advanced Excel Features

634

FIGURE 30.5

Use the Highlight Changes dialog box to track changes made to a workbook.

You can also specify the period to track (When), which users to track (Who), and specify a range

of cells to track (Where). If you enable the Highlight Changes on Screen option, each changed cell

displays a small triangle in its upper-left corner. And when a changed cell is selected, you see a cell

comment that describes what change was made (see Figure 30.6).

After you select the option(s) that you want, click OK to close the Highlight Changes dialog box

and enable tracking. To stop tracking changes, choose Review ➪ Changes ➪ Track Changes ➪

Highlight Changes again, and then clear the Track Changes While Editing check box.

Caution
When tracking changes is enabled, the workbook always becomes a shared workbook, which severely limits
the types of changes you can make. Shared workbooks are discussed earlier in this chapter (see “Sharing
Workbooks”). n

FIGURE 30.6

Excel displays a descriptive note when you select a cell that has changed.