Tracking Changes in Excel

Excel's Track Changes Feature

The Track Changes feature in Excel is used to record a history of any
changes made to the workbook. You can log user names, the type of
change, the date the change was made and where about in the workbook the
change occurred. When you decide to use the Track Changes feature, you
must be aware that this forces your workbook to automatically behave as a
shared workbook, although you do not have to store the workbook where it can
be accessed by others.

There are two menu items under Track Changes. These are
Highlight Changes and Accept or Reject Changes. The Accept or Reject Changes
is greyed out and will only be available after Highlight Changes has been chosen and set.

The Track Changes command is found via
Tools>Track Changes>Highlight Changes.
When you select you will see the Highlight Changes dialog box. The first thing that we need to do is check the
Track changes while editing the checkbox. This will make the When, Who, Where and
Highlight changes on screen all available. Notice that the List changes on a new sheet checkbox is not enabled. This will only be available if we have already saved the Workbook as a
shared workbook.

WHEN

This is where we can specify when Excel will display changes and has four choices

Since I Last Saved

All

Not Yet Reviewed

This option means you can highlight changes you have not yet reviewed. You review changes by selecting
Accept or Reject Changes under Tools>Track Changes.

Since Date

If you select this you can type in any valid date. The default date will be the current date.

WHO

There are two choices here they are :

Everyone

This is determined by the user name under
Tools>Options-General/Username

Everyone but Me

WHERE

You can nominate a range of cells to highlighted changes on, or leave it blank and it will apply to all sheets and cells.