Tracking and reviewing changes

When you and your colleagues change a workbook's contents, it can be hard to…determine who made what change and when.…If you have planned to have several individuals edit a workbook, turning on…Change Tracking lets you see all the changes.…What's more, you can review the changes and accept or reject them as you wish.…So here I have a workbook, and it has just various sales levels, and the idea is…that I want to be able to track the changes and see which users has made them,…and then give myself the opportunity to either except a change or reject it.…

So here is how you do that.…First, you make sure that you are on the Review tab of the Ribbon and then…in the Share group, you click Track Changes, and in that list, you click Highlight Changes.…In the Highlight Changes dialog, you select the Track changes while editing check…box, then you can control which changes that you want highlighted.…I don't believe that I have ever selected anything except for All here and then…have everyone tracked and throughout the entire worksheet, and also you…