❮ Back

Microsoft Office: 12 Great Tips

The Standard

Microsoft’s Office remains the most popular and powerful software suites available, and many of us spend a good part of each day using its applications such as Word, Excel, and Outlook. Here are some helpful ways to get the most out of your Office experience.

Outlook

1. Set a reminder to reply to a message Right-click the message you want to set the reminder for, point to Follow Up, and then click Add Reminder. In the Due By list, click the date when you have to complete the reply. In the second list, click a time. In the Flag color list, click the flag color you want, and then click OK.

2. Display several days side by side in Calendar In the date picker (the calendar in the upper-left corner of the Calendar window), drag over the dates that you want to view.

3. Switch between time zones Add a second time zone and switch between time zones for all Windows-based programs. Click Swap Time Zones in the Time Zone dialog box (Tools menu, Options dialog box, Calendar Options dialog box). You can also label the time zones you use most often so that you switch quickly between them.

4. Add a new contact from an e-mail message Open the message. In the From field, right-click the name you want to make into a contact. On the shortcut menu, click Add to Outlook Contacts.

Word

5. Jump to different sections of a document quickly To view a document’s organization and jump to different sections, on the View menu, click Document Map.

6. Create a horizontal line or across the page Press and hold the hyphen key to make at least three hyphens, and then press ENTER. To create a thicker line, hold the SHIFT key down at the same time, making at least three underlines before pressing ENTER. If you’d rather just create a page break, press CTRL+ENTER.

7. Navigation Keystrokes To move to the previous or next word, press CTRL+LEFT ARROW or CTRL+RIGHT ARROW. To go to the beginning or end of a document, press CTRL+HOME or CTRL+END.

8. Compare and Combine. On the Review tab, in the Compare group, click Compare, and then click Compare again. Enter the documents in the dialog box, and click OK. you can then merge comments and changes from two documents into one document by clicking Combine.

Excel

9. Select the first or last cell in a worksheet or list Press CTRL+HOME to select the first cell on the worksheet or in an Excel list. Press CTRL+END to select the last cell that contains data or formatting.

10. Select the contents of a cell using the keyboard Press F2 to select the contents of a single cell without using the mouse — it’s that simple. Use SHIFT+arrow keys to select and then edit or delete particular words or numbers within the cell.

11. Change rows into columns (and vice versa) Select the row or column you want to change, press CTRL+C to copy it (or CTRL+X to cut it), and then put your cursor in the top cell where you want to transpose the content. On the Edit menu click Paste Special and then click Transpose.

12. View two worksheets in the same workbook side-by-side (Excel 2007) On the View tab, in the Window group, click New Window, then click View Side by Side. In the Compare Side by Side dialog box, click the worksheets that you want to compare. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

We hope these tips will make your Office experience faster, happier and more productive!

Happy computing!