Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile 2003 to 2007 Compare Versions In Windows SharePoint Services 2.0 and Windows SharePoint Services 3.0, document libraries have the ability to track document versions. However, versioning must first be enabled in the document library settings. After you enable versioning, you can click the document menu, and then click Version History to open each version of a particular document. With Microsoft Office Word 2007, you can use the Compare feature to compare online document versions and see exactly what changes were made. 1. Click the Review tab, and then click the Compare button. 2. Click Compare, click Compare again, and choose the original document and the revised version that you want to compare. Depending on the type of versioning enabled in the document library, you can compare the open version against the last version, the last major version, or any specific version saved to the server. Identify Duplicate Values in an Excel Table In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting. 1. Select the list in which you want to identify duplicates. 2. Click the Home tab on the Ribbon. 3. In the Styles section, click Conditional Formatting, point to Highlight Cells Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete. • Tips and Tricks Web site • Microsoft Office Online • Help Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery. To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site. Legal information Microsoft Corporation One Microsoft Way Redmond, WA 98052 Sign up for other newsletters | Unsubscribe | Update your profile © 2008 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement