If you’ve ever used track changes in Microsoft Word, this is a similar concept in that the Excel program will record who is making which changes each time the workbook is accessed. Here’s the difference, though. You won’t see those changes on the screen unless you ask Excel to highlight them.
Turning on the Track Changes Feature
Click the Track Changes drop-down arrow in the Changes group on the Review tab
Choose Highlight Changes
Figure 30. Highlight Changes Dialog Box
3. Check Track changes while editing. This also shares your workbook.
4. Set your Highlight which changes options
5. Check Highlight changes on screen
Figure 31. Workbook Save Confirmation Dialog Box
6. Click OK to save the workbook