This feature of Excel is designed to track changes made by users or yourself.
This function is primarily made to track changes made to workbooks by shared users on a network, so if you want to highlight the changes you have made only then there are are a couple of features you must also turn on— workbook sharing and change history.
On your Review Ribbon (2007) or for earlier versions of Excel…
1. Tools menu
2. Track changes
A dialog box appears- make sure the track changes while editing box is selected, select the highlight changes on screen option then click ok.
You are all ready to check your changes to your workbooks.
As you can see every change can be either seen by holding the cursor over the dialog box on the left or can be seen on the History Worksheet Tab at the bottom of the workbook.
As seen in the example above I have changed numerous cells. It contains great information as to the time and date, the sheet amended as well as the new value.- How Big Brother is that!?.