• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Revision Tracking

Excel's Revision Tracking feature enables multiple reviewers to edit a document without actually changing it. Instead, each reviewer's markups are displayed in the document window. At the conclusion of the reviewing process, someone with final say over document content reviews all of the edits and either accepts or rejects each of them. The end result is a final document that incorporates the accepted changes.

To turn revision tracking on or off

1.
Choose Tools > Track Changes > Highlight Changes (Figure 14).

Figure 14. Use commands on the Track Changes submenu to set up and use Excel's revision tracking feature.


2.
In the Highlight Changes dialog box that appears (Figure 15), toggle check boxes to set up the revision tracking feature:

Figure 15. The Highlight Changes dialog box lets you enable and configure the revision tracking feature.


  • Track changes while editing enables the revision tracking feature. Turn on this check box to track changes. Turn off this check box to disable the revision tracking feature.

  • When enables you to which changes should be tracked based on when the changes were made. If you turn on this check box, choose an option from the pop-up menu (Figure 16).

    Figure 16. Use these two pop-up menus to specify which changes to track based on when they were made (top) or who (bottom) made them.


  • Who enables you to specify which changes should be tracked based on who made them. If you turn on this check box, choose an option from the pop-up menu (Figure 17).

    Figure 17. Use these two pop-up menus to specify which changes to track based on when they were made (top) or who (bottom) made them.


  • Where enables you to specify which changes should be tracked based on which cells the changes were made in. If you turn on this check box, enter a range of cells in the edit box beside it.

  • Highlight changes on screen displays revision marks in the document window.

  • List changes on a new sheet records changes in a separate History worksheet. This option is only available after you have saved the workbook file as a shared workbook.

3.
Click OK.

4.
If prompted, save the workbook file.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint