Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Turn Multiple Hyperlinks into Text in Microsoft Office Excel 1. Select the cell or group of cells that contain hyperlinks, right-click, and then click Copy. 2. Select the cells where you want your text to go (this might be the same selection as in step 1). 3. Right-click, and then click Paste Special. 4. In the Paste section, click the option that you want applied to the text (such as Values or Comments), and then click OK. 2003 to 2007 Categories and Tasks In Microsoft Office Outlook 2003, you can use colored quick flags to flag e-mail messages for follow-up based on their relation to each other. For example, you can use blue flags for action items related to an upcoming sales meeting, yellow flags for personal items, and red flags for urgent issues. However, these flags are visual cues only; they do not automatically create an Outlook task that you can track and manage. In Microsoft Office Outlook 2007, colored quick flags are broken out into Colored Categories and Flags. If you need to visually group related items together, you can assign a color category. If you need to act on something, you can assign a flag. When you flag a message in Outlook 2007, it's automatically added to your Outlook task list, your calendar, and the To-Do Bar (which shows your upcoming appointments and tasks for the day). You can assign categories and flags by right-clicking the appropriate icon in your Inbox, or by opening the e-mail message and clicking the commands on the Ribbon. • 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