Friday, October 24, 2008

Daily Tips and Tricks Special Delivery

Tips and Tricks Special Delivery
Making tomorrow more productive than today
For Microsoft Office Excel 2007
Microsoft Office Excel 2007
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.


.
Side by Side
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.

2003 vs. 2007 Side by Side

Quick Links
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
Microsoft

Your cOmment"s Here! Hover Your cUrsOr to leave a cOmment.


Subscribe to: Post Comments (Atom)