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
Choose Tools: Track Changes: Highlight Changes…
Figure 11. Highlight Changes Dialog Box
2. Check Track changes while editing. This also shares your workbook.
3. Set your Highlight which changes options
4. Check Highlight changes on screen
Figure 12. Workbook Save Confirmation Dialog Box
5. Click OK to save the workbook