Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: 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.
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.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2869) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Resolving Revisions.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Combo boxes can be a great way of getting user input in a worksheet. Here's how to add a combo box to your worksheet and ...
Discover MoreNeed to display your worksheet in different ways? A quick way to do this is to create views, as described in this tip.
Discover MoreYou've turned on Highlight Changes, but how do you know what has been changed? This tip explains how Excel displays those ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: 
Comments