1-866-245-5224 sales@keystonelearning.com

Excel 2003: Tracking Changes

Excel 2003: Tracking Changes

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

     
  1. 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