Here's our Microsoft Office Tip for.. March 22, 1999
Click Here to see a complete list of all of our previously released Tips!
Track Changes in Excel Worksheets
There you are, working away at making changes to an Excel worksheet. You decide it's time to quit for the day. The next morning you need to continue making the changes, but you're not entirely sure where you left off.
You can make your job easier if you use Excel's Tracking feature. To track your changes, select Tools, Track Changes, Highlight Changes, then select the Track changes while editing check box. For now, select the check boxes labeled When, Who, and Highlight Changes On Screen. Click OK to close the dialog box. (The Where option allows you to select a specific range of cells to monitor.)
Now all your changes will be highlighted on the screen and you'll have no doubt about what has been changed. When you open a worksheet again after a period of inactivity, you need to choose Tools, Track Changes, Highlight Changes to make the revisions visible.