Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile To Paste Values Instead of Formulas Sometimes you want to copy the values within a series of cells rather than the formulas in those cells. Here's what to do: 1. Select the cells that contain the values you want to copy. 2. Right-click the selected cells, and click Copy. 3. Select the cells into which you want to paste the copied values. 4. On the Home tab, in the Clipboard section, click the down arrow on the Paste button. 5. Click Paste Values. Group Contacts by Category You can use categories in Microsoft Office Outlook to add criteria and areas of interest to your contacts. Then when you have a specific announcement to make, you can get the right information to the right people quickly. Here's how: 1. Open each contact in Outlook. 2. Click the Categorize list. If the category you want isn't in the list, click All Categories, and then click New to create a new category. 3. To group your contacts by category, click View, point to Current View, and then click By Category. Note that you can't sort by category, because in a single category field, there may be several entries separated by semicolons; if you assign more than one category to a contact, that contact will be listed under multiple categories. 4. Select the icon at the top of a category, and double-click it to collapse the group. 5. Select the icon again, and then click New Message to Contact to send your e-mail message to everyone in that category. Be careful when working in the Category view. If you delete a contact under one category, you're deleting the contact from your address book completely. Instead, do the following: 1. Right-click the contact, and point to Categorize. 2. Click a selected category to clear it, or click Clear All Categories to remove all categories from the contact. • 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 © 2009 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement