The 2007 Microsoft Office system

Customize Which Commands Appear on the Status Bar

The Status bar is the bar that appears across the bottom of the screen in many programs and provides information about the active file. For example, the Status bar in Microsoft Office Word provides information such as active page number, number of pages in the document, and word count.
In most cases, you can also click the Status bar option for more information or to perform an action. For example, click Page in the lower-left corner of Word to access the Go To tab of the Find and Replace dialog box.
In several of the 2007 Microsoft Office system programs, including Word, Excel, PowerPoint, and Access, you can customize what appears on the Status bar. To do this, right-click the Status bar, and then click to show or hide the options you want.

Microsoft Office Excel 2007

Paste into Non-sequential Cells in Excel

You can use the CTRL key for multiple selections. Sometimes, you want to copy a formula or piece of data into a series of non-sequential cells in Microsoft Office Excel. You can do this quickly without having to paste into each cell individually.
1. Copy the data from the source cell.
2. Hold down the CTRL key as you click to select each destination cell.
3. After all the cells are highlighted, paste the data by pressing CTRL+V. You have to paste only once.
Similarly, you can type data into a series of cells simultaneously.
1. While holding down the CTRL key, click all the cells that you want to type the same text (or value) into.
2. Type the entry, and then press CTRL+ENTER. The text will be added to all the selected cells.

Microsoft Office SharePoint Server 2007

Save Time Editing Lists

To add content to a Microsoft SharePoint list, especially if it involves more than one item (for example, when you're creating a contact list), rather than adding each item at a time, you can copy in bulk.
1. Click Edit under Datasheet View on the bar at the top of the list.
2. Type in items or copy them from an existing Microsoft Office Excel spreadsheet.
3. Click Save, and then click Close.

Microsoft Office Outlook 2007

Rearrange the Outlook Window for Smaller Screens

You can create plenty of room on the screen in Microsoft Office Outlook 2007, even with all of the new views in Outlook. Here's how:
1. Click the chevrons at the top of the folder pane and the To-Do Bar. This will give you a clear view with summary bars for the folders on the left and for the To-Do Bar on the right.
2. Click Navigation Pane on the summary bar at left to get a pop-out view of the full navigation pane.
3. Click To-Do Bar on the summary bar at right for a similar pop-out. The resulting view has plenty of room for e-mail messages and the preview pane, even on a small laptop screen.


Post a Comment