Resolving Revisions

Excel allows you to easily track revisions made to your workbooks. At some time you will want to resolve your changes to get rid of the revision marks. This is typically done as you are finalizing a workbook, after you are sure that the changes are something you really want to keep. Excel allows you to automate much of the resolution process.

1. Choose Track Changes from the Tools menu. This displays a submenu.
2. Choose Accept Or Reject Changes from the submenu. Excel displays the Select Changes to Accept or Reject dialog box. (Click here to see a related figure.)
3. If desired, use the radio buttons to indicate the criteria by which you want to review changes: when changes were made, who made them, and where they were made in the workbook.
4. Click on the OK button to begin the reviewing process. Excel highlights an edited cell with an animated cell border, and information about the edit is displayed in the Accept or Reject Changes dialog box.
5. Click your mouse on Accept or Reject, depending on whether you want Excel to accept or reject the proposed edit. Excel moves on to the next change in the workbook.
6. Repeat step 5 for each remaining edited cell.

You will notice that when you are done reviewing changes, Excel still shows edited cells with the blue border and tracking changes indicator. The only way to get rid of these (after you have reviewed all the changes) is to turn off the revision marking.