Have you ever edited something, then realized you liked it better the way it was? Have you ever sent an excel sheet to someone to add into it and wondered what was changed? Guss what, Track Changes in Excel 2010 does all this.
Track Changes gives you the ability to edit or change data in the worksheet and make note of those changes. MS Excel 2010 will make note of the changes by highlighting the outside of the cell with a different color.
In the upper left hand corner of the cell, an inverted triangle will also appear. Clicking on that will tell you exactly what changes have been made so you know what you’ve added, what you’ve deleted, and what formatting changes you have made. This also helps when you have several people changing and editing a workbook.
To turn on Track Changes in MS Excel 2010:
go to the Review tab and click Track changes in the Changes group, then select Highlight Changes.
Put a check mark in the box beside Track Changes While Editing, Then, you can select when, who, and where at in the worksheet that you want to track changes.
Now, when you or anyone else makes changes or edits this excel sheet, these changes will be noted by assigning a color by MS Excel 2010. For example, John changes may show as a cell highlighted in red, Sara in blue, etc. These are assigned by default. You cannot assign colors to users.
When you click on the triangle in the upper left hand corner of the cell, the user’s initials will appear. This is another way to let you know who made what changes.
Accepting or Rejecting Changes:
Whenever you or someone else makes a change to the excel worksheet using Track Changes, you can then decide whether to accept or reject the change.To do this, go to the Review tab, click Track Changes, then select Accept/Reject Changes. This dialogue box will appear:
You can select when the changes were made that you want to accept or reject, who’s changes, and where at in the worksheet that you want to review changes. Click OK when you’ve selected which changes. A new dialogue box will appear:
It shows who made the change, what change was made, then gives you the option to accept the change, reject it, accept all changes made in the worksheet, or reject all of them.