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

Excel 2007: Tracking Changes

Excel 2007: 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. Click the Track Changes drop-down arrow in the Changes group on the Review tab
  3. 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