Microsoft Office Tutorials and References
In Depth Information
Tracking and managing colleagues’ changes
When you are ready to accept or reject changes, click OK. The Accept Or Reject Changes
dialog box opens and displays the first change, which is described in the body of the dialog
box. Clicking the Accept button finalizes the change; clicking the Reject button removes the
change, restores the cell to its previous value, and erases any record of the change. Clicking
Accept All or Reject All finalizes all changes or restores all cells to their original values, but
you should choose one of those options only if you are absolutely certain you are doing the
IMPORTANT Clicking the Undo button on the Quick Access Toolbar or pressing Ctrl+Z will
not undo the operation.
You can create an itemized record of all changes made since the last time you saved the
workbook by adding a History worksheet to your workbook. To add a History worksheet,
click Track Changes in the Changes group, and then click Highlight Changes to open the
Highlight Changes dialog box. Select the List Changes On A New Sheet check box. When
you click OK, a new worksheet named History opens in your workbook. Excel will delete the
History worksheet the next time you save your workbook.
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 workbook located in the Chapter14
practice file folder to complete this exercise. Open the workbook, and then follow the
On the Review tab, in the Changes group, click Track Changes , and then click
Highlight Changes to open the Highlight Changes dialog box.
Select the Track changes while editing check box to activate the Highlight which
changes area, and then clear the When check box.