Excel: What Happened? (Page 1) 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
 

Track Changes

You can keep track of each person who reviews this spreadsheet and when they made their changes.

 

Each reviewer's changes can be highlighted in a different color. If you chose to Track Changes, you can see which changes were made, who made the changes and where you can find their changes.

 

Try it: Track Changes
Go to Review->Changes.
Select Track Changes.

As you review the tracked changes, you can choose to Accept or Reject those changes.

 

Review ->Changes ->Track Changes

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 5. Collaborating and Securing Data

  5.1. Manage changes to workbooks: Track and manage changes