Outlook
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
WORK
WITH VERTICAL BLOCKS OF TEXT
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.
KEYBOARDING YOUR ACCENTS
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.
EXCEL
SELECTING
CELLS WITHOUT USING THE MOUSE
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.
EXEL
- RETURNING RANDOM NUMBERS WITH PRECISION
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.
=RAND()*10
To
generate a real number between specific minimum and maximum values,
use the following formula and specify values for minimum and maximum.
=RAND()*(maximum-minimum)+minimum
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.
=RANDBETWEEN(minimum,maximum)
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.
=VLOOKUP(RANDBETWEEN(mymin,mymax),myrange,myoffset)
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].
Fonts
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.
