Set a default return address for envelopes in (Word
97-2000-2001-2002)!
You can make it easier to create printed envelopes by saving a
default return address in Word. To do so, choose Tools | Options
from the menu bar, then click on the User Information tab in the
Options dialog box. Enter your default return address in the
Mailing Address text box (including your name or your company's
name), and then click OK. The next time you create an envelope by
choosing Tools | Envelopes And Labels from the menu bar (Tools |
Letters And Mailings | Envelopes And Labels in Word 2002), the
default return address automatically appears in the Return Address
text box on the Envelopes sheet.
Highlight Today's Date in Excel 2000!
Let's imagine that you'd like to have a cell appear in a different
color when that cell displays the current date. This sounds like a
job for Excel's Conditional Formatting Feature.
To set up an example current date indication, click cell A1 and
choose Format|Cells. When the dialog box opens, click Date and
then select a date format. Now, make sure cell A1 is selected and
choose Format|Conditional Formatting.
When the Conditional Formatting dialog opens, under "Condition 1"
select Formula Is and enter
=a1-today()
and then click Format. Select black text and click OK. Now, click
Add and for "Condition 2" use the following entries:
Cell Value Is Not Equal To 0 (zero)
Click Format and select red text. Click OK to close the dialog and
continue.
Enter today's date in cell A1 and the date should appear in red.
If you enter any other date, it will appear in black.
A Powerpoint 2000 Color Effect!
Have you seen The Wizard of Oz lately? The film starts out in
black and white. Then the movie suddenly switches to full color.
Why not try the same effect in a presentation?
To see how this would work, run PowerPoint and open a blank slide.
Choose Insert/Picture/ClipArt and insert any picture. Now, choose
Insert/Duplicate Slide to copy the slide. Go back to the first
slide now, and select the picture by clicking it. When the Picture
toolbar opens, click the Image Control button (second from the
left) and choose Grayscale.
Now, choose Slide Show/View Show. When the first slide appears,
click the mouse to move to the second slide. The ClipArt picture
remains in place, but suddenly appears in color.
|