TIPS & TRICKS

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.   

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:

Click: OK

Open Tools: Mail Merge: Edit

To Edit Master letter

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. 

Graphics

Looking for free graphics and images? 

1) Check out Barry's Clip Art for a vast array.

2) or EOS Development for really different designs

3) or for photos that are free go to WebShots.com or www.images.google.com

4) and more photos and clip art - Fotosearch

Choosing A Host For Your New Website

Some Tips to help you out.

1. Free Web site Hosting deals usually come with a hitch. You may have to pay for some of the other services you may need for your site such as credit card processing, or have to put up with  intrusive advertising, etc.

2. Choose a Host who can offer you a wide range of building tools such as basic templates, online applications, shopping cart technology, counters etc. etc.

3. Make sure that you host offers 24/7 support. You will need it at some time.

4. Check on their up time. Are they reliable. You don't need a host whose server is down frequently. That means people can't get to your website.

5. Price. You can pay anywhere from a few dollars to hundreds of dollars per month. Ask yourself, is the higher price getting more for my dollar? Only you know that.

Check Your Computer for Vulnerability from Outside Attacks

If you have a high speed access service - Cable or DSL - then you must have a firewall installed. This will prevent hackers from getting into your system. When using dial-up web access your computer your computer has a different IP address each time you use the Internet. But with high speed access, you maintain the same IP address all the time.. Thus you compute is prone to attack. You should install a firewall to protect yourself. Once you have done that here is a place to which you can go to check your vulnerability - https://grc.com/x/ne.dll?bh0bkyd2 . This site will benignly test your computer's security. Check it out!!! It is worth the trouble.

And if you are looking for a Free Firewall check out ZoneAlarm. It is a basic no frills program, but it does the job.

Using Your E-Mail Effectively 

by Birgit Pauli-Haack,
 birgit@hmsmg.com

Below are a few websites you may wish to check out for more information and assistance in using your e-mail more effectively.

MS Outlook Express Support & Info 

FAQs on Microsoft Outlook Express
http://support.microsoft.com/support/
default.asp?PR=oex

 

General Information About E-mail and Computer Viruses 


AVP Virus Encyclopedia 
www.avp.ch/avpve/

ICSA - International Computer Security Association 

www.icsa.net/html/communities/antivirus/
hoaxes/

CIAC - U.S. Department of Energy Computer Incident Advisory Capability 
hoaxbusters.ciac.org/

Don't Spread that Hoax! 
www.nonprofit.net/hoax/hoax.html

Urban Legends - About.com
urbanlegends.about.com/msubvir.htm

Anti-Virus Sites & Programs with Updates 


Symantec Antivirus Center (Norton AntiVirus) 
www.symantec.com/avcenter

McAfee - Virus Information Library (VirusScan)
vil.nai.com/VIL/ 

Sophos (Sophos Anti-Virus) 
www.sophos.com/virusinfo/

E-Mail Us

HMSMG - Tips  

© HMSMG  2005  All Rights Reserved