Weekly Internet Fixes Office 2000 News Letter

Oct 01, 2004Visit my new Chat Room!
 
Update your document's date automatically in Word 2000!
When creating a template or form letter that should always be printed with the current date, insert the date as a field rather than as text to avoid having to retype it with each printing.

Follow these steps:

1. Position your cursor where you want the date to appear in your document or template.
2. Go to Insert | Date And Time.
3. From the Available Formats box, select the date and time format you want to use.
4. Click the Update Automatically check box, and then click OK.

The date is inserted as a field. (To view the field code, right-click the shaded area and click Toggle Field Codes.) Each time you open or print your form letter, or create a new document from the template, the current date will appear automatically.

To make the date permanent, before saving the document, select the date and repeat Steps 2 through 4 above to clear the check mark from the Update Automatically check box.
Conditional Formatting in Excel 2000!
Conditional formatting is one of Excel's better features. It allows you to preset certain font styles, colors, and cell-background colors based on cell values. This can be very useful for highlighting important information and values outside an accepted range or providing a visual cue to associate value ranges with color codes.

The best part is that conditional formatting is very easy to set up. Just click the cells you'd like to format and select Format | Conditional Formatting. The Conditional Formatting dialog box lets you set up the conditions by which the formatting of the cell will occur. You pick the operator (between, equal to, less than, etc.) and the value or range of values. Click Format to open the Format Cells dialog box, where you can select the colors and styles to be used.

Each cell can have several conditional formats. For example, you might say that if a certain cell's value is between 20 and 50, the text should be blue on a yellow background. But you can format that same cell to exhibit red, bolded text on a green background if it contains a value between 51 and 100.
A PowerPoint Intermission Animation (2000)
When you're presenting a PowerPoint slide show, you might want to use an animated slide during the intermission period. You can set this up to run continuously until you start the next part of the show.

As an example, suppose you create a slide that contains only the title of your presentation using WordArt (choose Insert/Picture/WordArt). With the WordArt in place, right click it and choose Custom Animation. Click the WordArt object to select it. Next click the arrow at the right side of the "Entry animation and sound" list box and select Swivel from the list. Now click the Order & Timing tab and select the "Automatically" radio button. Leave the timing at the default of 00:00 and click OK to close the dialog box and apply the settings. Click Slide Show/Set Up Show. When the dialog box opens, select the "Loop continuously until Esc'"check box and click OK to close the dialog box. Next choose Slide Show/Slide Transition and select the "Automatically after" check box. Set the time to two seconds and click Apply to close the dialog box and save your new selections. Now press F5 to view the animated slide.
Things to Note
Many Folks ask us how we cover so many topics. Most of our answers come from a Database with 42 Topics and over 8000 entries. This came from over 8 years of online help. Couple that with over 5000 documents on various subjects we have the ability to answer most of your questions.
  © Internet Fixes 1999-2004