Thursday, September 01, 2005

MS Office Tips

Español | Deutsche | Français | Italiano | Português

For those of us fortunate enough to have Microsoft Office, I have collected these tips. They don’t work for other applications, but I decided to share these with you.

Zooming with Office: If you have a scroll wheel mouse, you can use the wheel to enlarge or shrink the screen size of your document or worksheet. Hold down the key and spin the wheel toward yourself to zoom out or away from yourself (forward) to zoom back in. You may need to enable this feature to make it work properly; to do so,in Word or Excel, choose Tools, Options, click the General tab, and check the Zoom on Roll with Intellimouse box (a scroll mouse of any brand will work).

The shortcut to shortcuts: Not sure of a keyboard shortcut, or just want to learn more of them? Let Office help you by turning on the keyboard shortcut display. Select Tools, Customize, click the Options tab, and check the Show shortcut keys in ScreenTips box. Now when you hover the cursor over something like a toolbar icon, no only will a description of the icon function pop up, but so will its keyboard shortcut (if available).

A Word for the Wise Automate with AutoText: Word has a surfeit of built-in boilerplate phrases ready to be summoned with a mouse click instead of requiring you to manually type them. To access AutoText phrases instantly, right-click anywhere on the toolbar area and select AutoText. You'll find a menu of phrases (such as "To Whom it May Concern") as well as a button for adding your own AutoText entries.

Return to where you left off: Wouldn't it be nice to quickly return to the place in your document where you left off when you last saved? Press - and you're there. In fact, you can repeat the key combo to go to the last three places you made changes.

Two windows, one screen: When you're editing a document or just want to compare parts of one, it's particular handy to have two independently scrollable window panes of the same document. Select Window, Split and a split bar will appear. Using your mouse, move the line to where you want the split to appear and then click the mouse. Any changes you make in one pane will be made in the other because only the number of viewing/editing panes has doubled--not the number of copies of the document. To return to a single-window view, double-click on the split bar.

Excelling With Excel

Changing directions: With so many places (or cells) to go to in Excel, navigation expertise is essential to productivity. One of the simplest--but often overlooked--forms of navigation is the Enter key. By default, when you press Enter, the cursor goes to the next cell down. But it doesn't have to be that way. To change the default direction to right, left, or up, select Tools, Options, click the Edit tab, check the Move selection after Enter box, and then select your direction choice from the pull down menu. Then click OK.

Moving from one worksheet to another is as simple as clicking the Sheet tabs at the bottom of the screen. But if you want to keep your hands on the keyboard, press - and - to toggle through each sheet.

Time for a page break: Unlike with dating, in Excel, breaking up is not hard to do--but clean page breaks are essential. Have you ever printed a worksheet only to find a few stray columns or rows orphaned on a separate page? To avoid this problem, preview where the page breaks are set to fall. Select View, Page Break Preview. The first time you visit, you will see a welcome screen that's not particularly helpful. Check the box offering not to show it again. Use the vertical and horizontal scroll bars to view the breaks. Pages will be marked with large labels and page breaks with bold lines. You can then adjust the break lines with your mouse.

To manually set a page break, select the cell that will be the first one on the next page. Choose Insert, Page Break from the menu. To remove a page break, select Insert, Remove Page Break.

Fill 'er up with AutoFill: Excel can remove the drudgery of entering sequences of numbers, dates, days of the week, months, or years, among other boilerplate items. All you need to do is enter one or two items of a sequence in succeeding cells (rows or columns) and AutoFill can do the rest. Here are some examples:

Fill in a series of numbers: To try this out, enter the number 1 in one cell and 2 in the next, then highlight both of those cells. Now hover your cursor over the small black square in the lower right of the selection until the cursor turns into a plus sign (not the plus sign with arrows). Next, drag the corner down or across and in each succeeding cell, Excel will fill the cells with increments of 1 (3, 4, 5, and so forth). If you originally entered 100 and 200, the cells would be AutoFilled with 300, 400, and so on.

Fill in dates: Similarly, enter a single day of the week or month of the year, and Excel will AutoFill each succeeding day or month. When it reaches the end of a series of named days, it will repeat them again in order until the end of your selection. At the end of a month's worth of dates, it will automatically go into the next month. Excel will even fill in a sequence of years or quarters beginning with the one you start with such as 2004, 2005, 2006 or Q1, Q2, Q3, Q4. By default, AutoFill copies both the formats and values of the cells you choose. To select one or the other, hold down the right mouse key while dragging. Upon release, choose Fill Formatting Only or Fill Without Formatting. If you don't like how AutoFill has filled cells, click AutoFill Smart Tag to display more options.

Looking Out With Outlook
Faster contacts with nicknames: Every contact record in Outlook includes a field called Nickname. While you could actually enter a friend's nickname there (which is what most users think it is for and therefore don't use it), it is a great way to make name matching more precise when sending e-mails.

To use this field, go to a contact's record, click the Details tab, and enter a name that you'll use as a shortcut for calling up the person's info. It can also be useful for differentiating similar close names. For instance, if you have a series of Smiths--Anne, Barrett, Charles--you could enter a nickname for each, such as AS, BS, or Chuck. You don't have to type the full name, or choose the right Smith from a pop-up list, to pinpoint the Smith you're addressing: you simply type their nickname into the "To:" field of your e-mail message.

Find a contact's address on a map: If your PC is connected to the Internet, you can get a map and driving instructions of a contact's address. Click Contacts on the Outlook bar, then select the contact. From the File menu, select Open, Selected Items. Under the Address button, click the down arrow, then click the address you want mapped: Business, Home, or Other. Now go to the Actions menu and click Display Map of Address. Outlook now goes to the MSN Maps Web site to pinpoint the address on a map. Use the controls on that page to further customize your exact directional needs.

Open Office has released a new version, 1.1.4, which further polishes up an already fine package. Download it. You will also need to download Java Runtime Environment since Open Office uses it to good advantage.