Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
If you are a Microsoft Word user, you may already be familiar with what is meant by the term revision tracking. If not, then you are in for a treat. In a nutshell, Excel allows you to keep track of the changes made to your workbook. Thus, you can see what has been added, deleted, or simply changed.
Revision tracking is normally meant for use in a shared environment, so you can track how other people may have changed a workbook for which you are responsible. However, it can also be a valuable tool even if you are the only one using a workbook. It can be used so you can see your own changes over time.
Revision tracking is turned on or off on a per-workbook basis. Thus, if you have two workbooks open at the same time, revision marking can be turned on in either, both, or none of the workbooks. You control revision tracking by choosing Track Changes from the Tools menu. This displays a submenu from which you should choose Highlight Changes. (Click here to see a related figure.)
To turn on revision tracking, simply select the check box at the top of the dialog box. If you later want to turn off revision tracking, you can display this dialog box again and clear the check box.
With revision tracking turned on, you can specify how you want this tool to be used by Excel. The three check boxes in the middle of the dialog box allow you to specify which changes should be highlighted, and the check boxes at the bottom of the dialog box indicate how the highlights appear. The center check boxes (When, Who, and Where) have more to do with resolving revisions, as discussed in a later tip.
At the least, you will want to make sure that the Highlight Changes On Screen check box is selected. This causes your workbook edits to be visible.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2868) applies to Microsoft Excel versions: 97 2000 2002 2003
Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.