Microsoft Office Tutorials and References
In Depth Information
In this exercise, you’ll turn on change tracking in a workbook, make changes to the
workbook, accept the changes, and create a History worksheet.
SET UP You need the ProjectionChangeTracking_start workbook
located in your Chapter14 practice file folder to complete this exercise.
Open the ProjectionChangeTracking_start workbook, and save it as
ProjectionChangeTracking . Then follow the steps.
1. On the Review tab, in the Changes group, click Track Changes , and then click
Highlight Changes .
The Highlight Changes dialog box opens.
2. Select the Track changes while editing check box to activate the Highlight
which changes area, and clear the When check box.
3. Click OK .
A message box appears, indicating that Excel will save the workbook.
4. Click OK .
The message box closes. Excel saves the workbook and begins tracking changes.
5. In cell E6 , type 16% , and then press Enter.
A blue lag appears in the upper-left corner of cell E6.
6. In cell E7 , type 14% , and then press Enter.
A blue lag appears in the upper-left corner of cell E7.