How to track Excel cell history?

Answer 1

Tracking Changes

1. Step 1

   Start Microsoft Excel and open the file you want to change.

2. Step 2

   Open the Tools menu and select Track Changes, then Highlight Changes.

3. Step 3

   In the Highlight Changes dialog box, select "Track changes while editing."

4. Step 4

   Select "Highlight changes on screen."

5. Step 5

   Open the When menu and select All.

6. Step 6

   Open the Who menu and select Everyone.

7. Step 7

   Click OK.

8. Step 8

   Click OK. This will save your changes and your file/workbook.

9. Step 9

   Enter your new changes.

   Accepting or Rejecting Changes
10. Step 1

    Open the Tools menu and Track Changes menu and select Accept and Reject Changes option.

11. Step 2

    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. Step 3

    Click OK.

13. Step 4

    In the Accept or Reject Changes dialog box, review the edits to the spreadsheet.

14. Step 5

    Select the Reject or Accept button for each