You might be used to turning on track changes in Word to see what others have done to your document – but did you know you can track changes in Excel as well?
To highlight the cells where changes have taken place, do the following
1) Click on the “Review” tab in the ribbon in Excel 2010
2) Look towards the right hand side of the ribbon and click on the “Track Changes” button
3) Click “Highlight changes”
A new menu box appears in which you can select some options as to how Excel tracks the changes. Make the selections as you like, then click ok.
To accept or reject the changes someone made, click on the “Track Changes” button again, then click “Accept/Reject Changes”
‘till next time!