Daily Tips and Tricks Special Delivery - Microsoft

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.

Keep Important Documents Handy at All Times When you click the Office button in the 2007 Microsoft Office system programs Word, Excel, or PowerPoint, you see a Recent Documents list, similar to that which appeared on the File menu in previous releases. However, in the 2007 release, you now see a pushpin icon next to each file name. Click that icon to pin the applicable document to the Recent Documents list so that it’s always accessible at a click. When you click the pushpin icon, it changes in appearance to show that the pin has been activated for that document. Also note that you can change the number of recent documents that appear in the list. To do this, click the Office button, then click [Program] Options (for example, Word Options), and then click Advanced. Scroll down to the Display section, where you’ll see the option to change the number of recent documents displayed. Manage Meeting Resources Here’s how Microsoft Office Outlook can help you schedule resources and plan meetings within a group. 1. Create a group schedule. a. Go to Calendar view in Outlook, and on the Actions tab, click View Group Schedules. b. In the Group Schedules dialog box, click New, and then type the name of your schedule. c. Click OK. 2. Add all the resources you need to the Group Members column (for example, all the conference rooms in your building). You will see the free/busy information for all the resources in one view. You can use the same technique to book other resources, like audio/video equipment. 3. Plan your meeting. a. By using the Group Schedule view, find the appropriate resources that are free for your time slot. b. Click the Make Meeting button, and then click New Meeting as Resource. 4. A meeting request form appears, prefilled with the time booking information and the resource allocation. Just fill in the rest of the meeting details, and then click Send. The resources you requested will be booked automatically for you.

Use Shape Operations to Customize Shapes You can split a shape into multiple shapes, cut pieces out of a shape, or merge multiple shapes into one. To customize shapes, first select the shapes on which you want to act. On the Shapes menu, point to Operations, and then click the operation you want from the available options. For example, to draw horizontal lines completely through a triangle, select the triangle and all lines, and then click Fragment on the Operations menu to create a custom pyramid diagram in no time. In this example, the fragment operation uses the lines to split the triangle and does not retain the lines. Delete a Meeting Without Notifying Invitees If you have set up a meeting, and your attendees have declined to come, it's obviously an irritation for them to then receive an e-mail message confirming the cancellation of the meeting. Instead, you can delete the meeting without sending a notification. 1. Right-click the meeting, and then click Delete. 2. In the notification e-mail message, delete all the addresses from the To field, and type your own e-mail address instead. 3. Click Send.

Use Your Own Pictures in SmartArt You can insert your own pictures into Microsoft SmartArt graphics in your presentation. 1. Click the Insert tab on the Ribbon, click SmartArt, and then click the SmartArt graphic that you want to insert. 2. Select the picture that you want to add to your presentation. 3. Right-click an individual shape in SmartArt, and then click Paste to insert the picture you selected. 4. Repeat steps 2 and 3 for each shape. 5. Complete your presentation by applying your preferred background design.