View tracked changes
- On the Tools menu, point to Track Changes, and then click Highlight Changes.
If the Track changes while editing check box is not selected, Microsoft Excel has not recorded any change history for the workbook.
- Select the changes you want to see:
All changes that have been tracked Select the When check box and click All, and then clear the Who and Where check boxes.
Changes made after a particular date Select the When check box, click Since date, and then type the earliest date for which you want to view changes.
Changes made by a specific user Select the Who check box, and then click the user whose changes you want to view.
Changes to a specific range of cells Select the Where check box, and then enter a range reference, or select a range on the worksheet.
- Select how you want to view the changes:
Highlighted on the worksheet Select the Highlight changes on screen check box. To view the details about a change, rest the pointer over a highlighted cell.
Listed on a separate sheet Select the List changes on a new sheet check box to display the History worksheet. This check box is available only after you've turned on change tracking and saved some changes.