MS Word Tips

Below are a few tips that may find helpful.

Microsoft Intellimouse – You can zoom in or out with the MS Intellimouse by holding down the ctrl on your keyboard as you move the wheel.

If you type one of the following sets of characters, Word will instantly replace the characters with a symbol.

(c) ©	(r) ®	(tm) ™
:( L	:) J	:\| K
<== ç	--> à	==> è
<-- ß	<=> ó

You can turn off the Auto Text replacement of these characters by going to INSERT Menu/Auto Text/Auto Correct Tab and remove the check mark in the box beside Replace Text as You Type. However, if you turn off Auto Text replacement it will turn off all Auto Text entries until you turn it back on.

1. Selecting Text

Using the mouse click one time and holding the mouse button down move mouse to ending point of desired text and release the mouse button. Also known as a DRAG SELECT

Select a word, move the mouse anywhere over the word and click two times.

Select a character at a time click mouse at beginning or ending of desired text and while holding shift key press the arrow keys (on key pad) as many times as necessary. You can also use the arrow up or down to select more than one line.

Select a Word at a time click mouse at the beginning or ending of desired text and holding shift and control keys press the arrow keys (on key pad as many times as necessary)

Select one sentence hold the control key down and click anywhere in the sentence.

Move the mouse to margin and when it turns to an arrow click once to get complete line. Hold and move mouse up or down to get more lines.

Move mouse to margin and when it turns to an arrow click two times to select paragraph

Move mouse to margin and when it turns to an arrow click three times to select complete document.

Select a paragraph, move the mouse anywhere over the paragraph and click three times.

Select all text in your document, press and hold down CTRL and then press A on the keyboard.

To select text from the location of your insertion point to the beginning of the document, press [Ctrl][Shift][Home] and Word highlights all of the text from the insertion point to the very first word in the document.

To select text from the location of your insertion point to the end of the document, press [Ctrl][Shift][End] and Word highlights all of the text from the insertion point to the very last word in the document.

2. More Tips

You cannot type or insert anything below the blinking horizontal line displayed on the screen. You have to press enter to move the line down. This will give you space to insert text or graphics.

To COPY Text press CTRL key while dragging selected text.

Mail Merge Instructions

Open Letter

Tools: Mail Merge

1. Create: Form Letter

2. Data Source: Get Data: Create Data Source

Type a new field name "Salesperson" in field name window
Check: Add Field Name button
Click: OK (Opens Save As Window)
Name db file: Salesdb
Choose: Edit DataBase
Enter the three client records below:

Field Name	1	2	3
Title	Mr	Mrs	Dr
First Name	John	Dorothy	Henry
Last Name	Smith	McAtee	Jones
Job Title	President	Treasurer
Company	ABC, Inc.	CCII, Inc.	Redi Med
Address 1	432 1^st St.	111 5^th Ave	10 S. Main
Address 2	Apt 20	Suite 111
City	Naples	Naples	Naples
State	FL	FL	FL
Postal Code	34109	34109-7162	34109
Country	USA	USA	USA
Home Phone	941-513-2280	941-513-1111	941-573-1234
Work Phone	941-513-2222	941-513-1112	941-513-1235
Salesperson	Kelley Conrad	Cathy Dotter	Kelley Conrad

Click: OK

Open Tools: Mail Merge: Edit

To Edit Master letter

Select Text to edit, choose field name from Insert Merge Field, and continue until all address fields and Salesperson name have been substituted. (Note that punctuation is in the Master Letter, not in the data fields).

More Word Tips

To start numbers or bullets you can just type a 1. Followed by a space or an * followed by a space. They would have to be at the beginning of a line. To stop the numbers or bullets just enter twice and that will remove the last and blank number or bullet.

1. example number 1 (it must have the period after the number followed by a space)

2. example number 2

· example number 1 (the asterisk must be followed by a space)

· example number 2

To quickly indent paragraphs use the Increase or Decrease Indent icon found on the format tool bar.

Don’t forget footnotes. Under Insert on menu bar.

To delete a row or column of a table. Select the row or column and use the CUT on the toolbar.

Hanging Indent Ctrl + T

Remove hang indent Ctrl + Shift + T

Insert Date Alt + Shift + D

Insert Time Alt + Shift + T

Shortcut Keys

Control + Home Takes you to the beginning of the document

Control + End Takes you the end of the document

Control + A Selects ALL text

Control + X Cuts text

Control + C Copies text

Control + V Paste text

Control + Z Edit Undo

Control + Y Repeat Command

Control + B Bold

Control +I Italic

Control + U Underline

Control +Shift+D Double Underline

Control + enter key Page Break

Control +F6 Switches between open documents

Font Sizes

Control + Shift + < Decreases font size in default increments

Control + Shift + > Increases font size in default increments

Control + [ Decreases font size by one point

Control + ] Increases font size by one point

Mail Merger

After completing the main document, to see an example of how the letter will look. Move the mouse over the <<ABC>> button located next to the Insert Word Field on the mail merge toolbar. You can view field names by clicking on the <<ABC>> button.

Excel Tips

Create an Excel Chart with the Push of a Button

This is a very old Microsoft Excel trick. To quickly create a chart, using only your keyboard, select the data you want to plot and then press F11. Excel automatically creates the chart for you.

Another way to do this trick: After you select your cells, press ALT+F1 and you'll get the same result.

Select an Entire Range of Cells in Excel

In Excel, if you want to quickly select the entire range of cells you're working on, press CTRL+SHIFT+ ASTERISK (*).

For example, if you have a list of customers in Excel, this command will select the entire list and the column headings, but not the empty cells around the list—so you get only the cells you need.

This tip is different from the Select All command, which selects every cell in the
worksheet—even the ones that you are not using.

Front Page 2000 Tips

Build Your Own Hover Buttons in FrontPage 2000

Have you ever wondered how to make the buttons on your Web pages change color, move, or light up when users point to them with a mouse? It's easy to do with Microsoft FrontPage® 2000.

First, you'll need to create two versions of the button you want to put on your page. One version that appears when the page first loads and another slightly different version that users see when they point to the button with a mouse. You can create your graphics using Microsoft PhotoDraw™ 2000 or any drawing program you use to create graphics for the Web.

Once you've created your graphics, here's how you put them on your page:

1. On the Insert menu, click Component, and then click Hover Button.
2. In the Link to box, enter the URL of the page or file you want to display when the button is clicked.
3. In the Button text box, type the text label for the hover button. Leave this box blank if the graphic you created already contains a text label.
4. Click Custom.
5. In the Button box, enter the URL to the picture you want users to see when they first open the page.
6. In the On hover box, enter the URL to the picture you want users to see when they put a mouse over the button. Then click OK.
7. In the Width and Height boxes, type the width and height of the picture in pixels, and then click OK. The size of the hover button must match the size of the picture you use for the hover effect.

And if you don't have graphics already created, you can select one of the built-in hover effects in FrontPage 2000, such as Glow or Bevel, to quickly add interactivity to any page on your site.