How to Keep Track of Changes in an Excel Document

When you're creating a spreadsheet with a group, it can be difficult to remember who made changes and why these changes were made. Use the Track Changes option in Excel to simplify this process. These steps work with Microsoft Excel 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel

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.

Tips & Warnings

• To review your changes later, select Close in the Accept or Reject Changes dialog box.
• Rejecting your changes will erase the change and restore the cell back to the original entry.