Comparing Draft Versions in an Excel Document

Because the Track Changes feature in Excel® is not activated (it doesn't work in the same way as Track Changes in Microsoft® Word), you will need to compare draft versions in order to find changes made by a reviewer or approver.

Note: Excel has no feature comparable to the Compare Documents feature in Word, so you must manually compare the draft versions.

To find and compare the different versions of a revised or declined Excel document,

  1. Open the document, click the Overview tab, and then click Version History.

The draft versions of the document, such as the original draft you submitted to review or approval, are listed in the Current Revision History area. The version listed on top is the one you'd see if you clicked Edit Document. The others are previous draft versions.

  1. To compare the current draft version with another one, click the other draft version link. This opens that version in a separate browser window.
  2. In the current draft version (the one you opened in step 1 above), click the Edit Document tab.
  3. Compare the two drafts.