Naming Excel Ranges And How To Follow The Naming Rules

When working with a large worksheet, it's a good idea to name the ranges that you will use for your calculation. To
see how this works, enter some numbers into a few cells and then choose Insert/Name/Define and type in a name (test is OK for this example). To prove that your named range is working, click somewhere away from the range and press Ctrl + G to open the Go To dialog box. Double-click Test, and Excel will go to the named range.There are some naming rules that you need to follow:

- A name can contain up to 255 characters. - You must use a letter or an underscore for the first character.
- After the first character, you can use letters, numbers, periods, or the underscore character.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Dragging Word Text With The Right Mouse Button

If you select text in Word 2000 and then use the mouse to drag it to a new location, the text moves to that new location and it no longer exists at the original location. However, if you use the right mouse button to drag selected text to a new location, Word will open a menu offering you some choices. You can move the text, copy the text, create a hyperlink, or just create a link.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I Can't Open My Attachment

When you cannot view an attachment, it may be because your computer doesn't recognize the file extension. First, make
sure you have the associated software installed on your system. If you have the application, save the attachment to
your hard drive, open the application and then try to open the attachment within the application. Also, don't be shy
about asking the sender about what type of file the attachment is.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Making Room For Headers In Excel

When you need to use headers that turn out wider than the cells, you can increase the cell width, or you can set the
header text on an angle and leave the cell width as it is. To do this, type in a header and then choose Format/Cells.
When the Format Cells dialog box opens, click the Alignment tab. Now you can use the Spin box labeled 'Degrees' to set
your text angle.

After you set the angle, click OK to save your setting and close the dialog box.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Viewing Special Files In Word

Let's imagine that you have a large number of files in your Word data folder. These files are not all DOC files--some are RTF, some are TXT, etc. So, you choose File/Open and then click the arrow at the right side of the 'File of
type' list box and select 'All Files (*.*). Now click Cancel.

The next time you choose File/Open, you will see all the files in your data folder. What if you want to see only RTF
files right now, but, you don't want to change 'Files of type' each time you need a new file? What you do is choose
File/Open and type in the 'File name' entry box '*.rtf'. Now, only the RTF files will appear and you can make your
selection.

- Sue Whitehouse

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Smaller PowerPoint Files

When you create a PowerPoint presentation to go on the road, you'll want to have the smallest files possible. One way to achieve this goal is to avoid using BMP files and use JPG instead. JPG files are usually highly compressed, and you really can't tell the ifference between the qualities of the two images when shown on a screen.

One way to make some of your JPG files even smaller is to use a freeware program called JPG Cleaner, which you can
download at http://www.pppr.sk/rainbow/ .

- Sue Whitehouse

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Using A Macro In All Excel Workbooks

If you write a macro in Excel, the macro is attached to the current and will not be available in other workbooks. If
you want to make a macro available to all workbooks, you can create them in a special workbook named personal.xls.

To do this, enter a macro in a blank workbook. Choose File/Save As and name the workbook 'personal.xls.' Now,
still in the Save As dialog box, navigate to C:\Program Files\Microsoft Office\Office\XLStart and click Save.

Next, choose Window/Hide and then choose File/Exit. When asked if you want to save changes, click Yes.

Your macro will now be available to all workbooks. Since personal.xls is hidden, it won't appear unless you choose
Window/Unhide, which is what you'll need to do to add or modify any macros.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Auto Correcting Partial Words In Word

Here's a little-used Word 2000 feature for you--you can use AutoCorrect to correct partial words. For example, if you
commonly type the ending 'tion' as 'toin,' you could configure AutoCorrect to correct just the ending. To do this, choose Tools/AutoCorrect. When AutoCorrect opens, type

toin

into the 'Replace' entry box. Now, type

tion

into the 'With' entry box. Click Add, then click OK.

If you now type in 'natoin' AutoCorrect will turn it into 'nation'. Note that you must be very careful about correcting partial words. You could end up incorrectly correcting correct words, turning them into incorrect words.

- Sue Whitehouse

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Changing The AutoEntry Direction In Excel

Suppose you'd like to type and number into an Excel cell and then press Enter to move to the next cell on the
right--not the next cell down. What you have to do is change the AutoEntry direction.

To make this change, choose Tools/Options. When the Options dialog box opens, click the Edit tab. Select (or leave
selected) the check box labeled 'Move selection after Enter.' Now, click the arrow at the right side of the 'Direction' list box and select Right. Click OK to close the dialog box and record your selection. To test the change, type a number into cell A1 and press Enter. Excel should move to cell B1.

- Sue Whitehouse

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Changing The Word Font Size

There is a very easy way to change the font size in a Word document. All you have to do is select the text you want to change and then press Shift + Ctrl + < (less-than sign) to make the font smaller and Shift + Ctrl + > (greater-than sign) to make the font size larger.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Previewing Web Pages In Word

When you create Web pages in Word (and many people do), you don't have to leave Word and run a browser to see how your Web page looks. All you have to do is choose File/Web Page Preview. This will cause your default browser (whether it's Internet Explorer, Netscape, or something else) to open with your current page loaded.

- Sue Whitehouse

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~