Filter

Set the criteria for filtering the list of changes on the List tab.

To access this command...

Choose Edit - Track Changes - Manage - Filter tab.

Date

Filters the list of changes according to the date and the time that you specify.

Set Date/Time

Enters the current date and time into the corresponding boxes.

Author

Filters the list of changes according to the name of the author that you select from the list.

Range

Filters the list of changes according to the range of cells that you specify. To select a range of cells in your sheet, click the Set Reference button (...).

Shrink/Max

Select the range of cells that you want to use as a filter, and then click this button to return to the filter list.

Comment

Filters the comments of the changes according to the keyword(s) that you enter.

You can also use regular expressions (wildcards) when you filter the comments.