Office 2007 tips and tricks

• Copying a Worksheet:

Here’s how to copy a worksheet to another place in your Excel workbook:
1. Click the tab of the worksheet that you want to copy.
2. Leave your mouse pointer on the tab.
3. Press and hold down the CTRL key.
4. Press and hold down your left mouse button and drag the worksheet that you want to copy to the left or right. Watch for the little black arrowhead that follows your mouse pointer as you drag left or right.
5. When you release the mouse button, Microsoft Office Excel inserts a copy of the worksheet where the arrowhead is pointing.

• Customize Your Quick Access Toolbar

In each 2007 Microsoft Office system program where you see the Ribbon (Word, Excel, PowerPoint, Access, and parts of Outlook), you also see a Quick Access Toolbar, which appears by default above the Ribbon, beside the Office button. To add the commands you use most to the Quick Access Toolbar in each program, right-click a command on the Ribbon, and then click Add to Quick Access Toolbar. You can also click the arrow that appears at the right edge of the Quick Access Toolbar, and then click More Commands to open the Customize tab of the Options dialog box for the program you are using. In this box you can add commands that don’t appear on the Ribbon, or create a custom Quick Access Toolbar for an individual document or template.

• For Microsoft Office Outlook 2007

Use Search to Find E-Mail Messages
In Microsoft Office Outlook, e-mail search helps you locate messages by keyword or phrase. You can also use search folders to find mail by type of message.

To locate specific keywords or phrases within e-mail messages:
Type a word or phrase in the Search box at the top of your Outlook Inbox. The search starts automatically as soon as you stop typing. Search results will appear in the main window of your Inbox. To return to your normal Inbox, click Clear Search (the green ×) to the right of the Search box.

You can enable search folders from the mail pane on the left of your Inbox. To expand the folders tree, click Search Folders. Outlook comes with three default search folders: For Follow Up, Large Mail, and Unread Mail.

To add new search folders, click File, point to New, and then click Search Folder.

• To build a custom search folder:

1. Click Search Folder, and then either click a predefined folder name, or scroll down and click Create a custom Search Folder.
2. Click Choose, give the new folder a name, and then click Criteria to fill in the search terms.

• 2003 to 2007 Document Information Panel

With the Document Information Panel in Microsoft Office Enterprise 2007 and Office Professional Plus 2007, you can edit document properties directly in the program.

1. Click the Office button, and then click Prepare.
2. Click Properties. The Document Information Panel appears below the Ribbon.
3. Enter the appropriate information and save the document.

Keep in mind, search engines like the ones included in Windows Vista and Microsoft Office SharePoint Server 2007 use document properties to deliver search results that are more relevant. So if you want to make something easier to find, make sure your document properties are up to date.

• For Microsoft Office Outlook 2007

Choose a Signature for Different Recipients in Microsoft Office Outlook 2007
If you want to use a different e-mail signature for different recipients (a different one for coworkers than for customers, for example), you can change your signature with two mouse clicks. Right-click your signature, and then click the other signature that you want to use.

• Zooming to Fit a Selection

1. Select the range of cells that you want to focus on.
2. Click the View tab, and then click Zoom to Selection.

• Fine-Tuning Objects in Presentations

When working with text in Microsoft Office PowerPoint, you can use the F2 key to switch between selecting text in a placeholder and selecting the placeholder itself. So the next time you've edited some text and want to reposition it on the slide, instead of clicking the tiny edges of the box, just press F2. The entire text box will instantly be selected for you, ready for alignment.