How to Keep Track of Changes in an Excel Document

Tracking Changes
1. Start Microsoft Excel and open the file you want to change.
2. Open the Tools menu and select Track Changes, then Highlight Changes.
3. In the Highlight Changes dialog box, select 'Track changes while editing.'
4. Select 'Highlight changes on screen.'
5. Open the When menu and select All.
6. Open the Who menu and select Everyone.
7. Click OK.
8. Click OK. This will save your changes and your file/workbook.
9. Enter your new changes.
Accepting or Rejecting Changes
10. Open the Tools menu and Track Changes menu and select Accept and Reject Changes option.
11. In the Select Changes to Accept or Reject dialog box, select 'Not yet reviewed' to see all changes or 'Since date' to see changes after a certain day.
12. Click OK.
13. In the Accept or Reject Changes dialog box, review the edits to the spreadsheet.
14. Select the Reject or Accept button for each edit.