Show All

View the History worksheet

1. 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.

2. Select the When check box and click All.
3. Clear the Who and Where boxes.
4. Select the List changes on a new sheet check box.
5. Click OK, and then click the filter arrows next to the column labels on the History worksheet to find the information you want.

Note  Saving the workbook removes the History worksheet. To view the History worksheet after saving, redisplay it.