Jim Kerr - Alaska Juggler
  Office tips

 Office trix - The Microsoft variety





About Jim

Contact Jim

Computer Trix

Site Map


To create a rule in Outlook that will allow you to divert the different
TechMails messages to a specific folder, please follow these steps:
1. Create a folder in Outlook for your future TechMails.
2. Go to Tools | Rules Wizard and click New.
3. Select Check Messages When They Arrive and click Next.
4. Check the box next to With Specific Words In The Sender's Address.
5. Click on the Specific Words link and type newsletters in the resulting dialog box.
6. Click OK and then click Next.
7. Select what you want to do with the message.
8. Click on the Specified link.
9. Select the folder you created for future TechMails and click OK.
10. Click Next two times.
11. Click Finish and then click OK, and you've done it!

Word Tricks
Have you ever needed to copy or delete a vertical block of text that spans two or more lines? If so, you may have resorted to copying or deleting the text one row at a time, a process that's time-consuming
and fraught with the potential for errors.
Fortunately, Word makes it easy to select and copy (or delete) a vertical block of text. The trick is to hold down the [Alt] key while you click and drag with the mouse.
To demonstrate this trick, open any document that contains two or more rows of text. Hold down the [Alt] key, click anywhere in the middle of a line, and then drag up or down and to either side. As you move the mouse, Word will select a rectangular block of text.
Press [Ctrl]C to copy or [Ctrl]X to delete the selection. Click where you want to place this block of text, and then go to Edit | Paste or press [Ctrl]V. This tip comes in handy when you need to extract the "middle" column from rows of text.
NOTE: This tip doesn't apply to tables. If you need to copy or delete a column from the middle of a table, click the topmost cell to select the column. Then you can copy or delete the selected column.
Default line spacing
You can set the default line spacing in Normal.dot, the template used for new documents. In Word 2000, choose Tools | Options and click on the File Locations tab. Find User templates in the list—its folder location will probably be displayed in a useless compressed format such as C:\...\Microsoft\Templates.

Double-click on that list item to bring up the Modify Location dialog. Most likely you still won't be able to see the entire location, but if you press Ctrl-C as soon as the dialog appears, the location will be copied to the Clipboard. Press the Esc key twice to close the Modify Location and Options dialogs.
Now choose Open from the File menu, click in the File name: box, and press Ctrl-V to paste the location from the Clipboard. You'll find Normal.dot in the file list. Open it. Select Paragraph from the Format menu, choose 1.5 lines in the Line spacing: list, and click on OK. From now on, when you create a new document, its line spacing will default to 1.5.

Word offers a couple of ways to create accented characters. First, you can always go to Insert | Symbol and select an accented letter from the various character sets. Second, you can use keyboard shortcuts to add accents to the appropriate letters. Here's how.
* To create a character with an acute accent, press [Ctrl]['] (that's [Ctrl] and the apostrophe), followed by the character. For example, to type a lowercase or uppercase E with an acute accent, press [Ctrl]['] and then type e or E.
* To enter a character with a grave accent, press [Ctrl][`] (apostrophe under the tilde), followed by the letter - à
* To add a tilde to a character, press [Ctrl][Shift][~], followed by the letter - ã
* To add a circumflex, press [Ctrl][Shift][^], followed by the letter - ê
* To add a dieresis, press [Ctrl][Shift][:] (the colon), followed by the letter - ë
But Word won't automatically add the accent to just any letter. For example, if you press [Ctrl]['] and type z or Z, Word will ignore the first keystroke because Z isn't a letter that ordinarily gets accented.
When you need to select an entire row or column, you probably reach for the mouse. The problem with using the mouse, of course, is that it requires you to move your hands away from the keyboard.
But if your users want to save time by performing as many tasks as possible without reaching for the mouse, here are some tips that can help. (These tips work the same way in Excel 97 and Excel 2000.)
* To select an entire column, click any cell in the column and press [Ctrl][Spacebar].
* To expand the selection to other columns, hold down the [Shift] key while you press the Left or Right Arrow key.
* To select an entire row, click any cell in the row and press [Shift][Spacebar].
* You can expand the selection by holding down [Shift] while you press the Up or Down Arrow keys.
* To manage the Excel window, press [Alt][Spacebar]. Then press the
appropriate hot key to select Restore, Move, Size, Minimize, Maximize,
or Close. This tip works in almost all Windows applications.
When you're developing a worksheet solution, you must often provide sample reports without the benefit of "live" data. To create realistic practice reports, the RAND and RANDBETWEEN functions can save the day.
The RAND function takes the form =RAND() and returns a random number greater than or equal to 0 and less than 1. For example, enter the following expression to generate a real number greater than 0 but less than 10.
To generate a real number between specific minimum and maximum values,
use the following formula and specify values for minimum and maximum.
But what if you don't need a real number? You can round the result of the RAND function to zero decimal places or use some other trick to convert the result to an integer. Or, you can use the RANDBETWEEN function, which returns an integer and takes the following form.
Suppose you want to use VLOOKUP functions to return random elements from a table whose lookup values are integers. Designate two cells for your minimum and maximum values and name them mymin and mymax. Then use a formula like the one below to return a value from a lookup table.
This VLOOKUP function returns the column designated by "myoffset" from a random row from "myrange."
These functions return new random values when you update the worksheet. You can update the sheet with the VBA Calculate command or by prompting the user to press [F9].
The usual method of installing new fonts in Windows 98 is to either use the Setup.exe program that comes with third-party font packs or to use the Install New Font menu command from the File menu in the Fonts applet of Control Panel. However, this menu option may be unavailable if attributes on the Fonts folder are incorrectly set; if you have been using the Attrib.exe command recently, this may be a side effect of your commands. The Fonts folder must have the System and Read Only attributes set for the Fonts applet to work properly.To reset the attributes, go to Start | Run and type
Command and click OK.

Now type
cd \windows where windows is the folder where Windows is installed, and press [Enter]. Then type
attrib +s +r fonts and press [Enter].
Restart Windows and check to see if the command has returned to the
Fonts applet. There are two other reasons that may cause the Install
New Font and other options to disappear from the menus.

Juggling |
Resume' | Diversions | Gravity | Music | About Jim | Contact Jim | Site Map