UNHCE has published a 12-page document with links and directions for several of the most popular features in Microsoft Word XP. TO access this document, go to:
http://extension.unh.edu/Intranet/ITDE/WordTips.pdf 

UNHCE has developed some tutorials for commonly used tasks. These two enable you to repeat table headers in WP documents.

To repeat table headers across multiple pages in Word, see: Repeating Table Headers (Microsoft Word XP)


To repeat table headers across multiple pages in Word, see: Repeating Table Headers (WordPerfect 10) 

As you type a document, Word automatically converts your quote marks
and apostrophes to "curly" versions that look more professional. When
working with a document from a different source that doesn't include
these smart quotes, you may want to convert them all so they look the
same. This is easy to do simply by using Word's Find and Replace
function. This tip explains how.

Read the full tip: http://wordtips.VitalNews.com/T0586 Courtesy of: Allen Wyatt's WordTips

Some printers allow you to print on paper from different sources. For
instance, a printer may have multiple paper trays, each bearing a
different type of paper. If your printer driver is up to date, you can
instruct Word to print to exactly the paper source you want used.

Read the full tip: http://wordtips.VitalNews.com/T0180
Courtesy of: Allen Wyatt's WordTips

A point is a typographical measurement. Points are used for many types
of measurements in Word, PageMaker and related applications. This tip explains how you can enter them directly into dialog boxes in Word.

Read the full tip: http://wordtips.VitalNews.com/T0075
Courtesy of: Allen Wyatt's WordTips

You can increase the flexibility of tables by creatively merging cells
to get just the look and layout that you need. This tip describes a
couple of different ways you can perform the merging tasks. It covers
using menus and the more flexible toolbar approach.

Read the full tip: http://wordtips.VitalNews.com/T0768
Courtesy of: Allen Wyatt's WordTips

Paragraph marks (created by pressing Enter) and line breaks (created
by pressing Shift+Enter) are two of the most common special characters
in a document. Word allows you to easily search for these characters,
using the method described in this tip.

Read the full tip: http://wordtips.VitalNews.com/T0007
Courtesy of: Allen Wyatt's WordTips

Sometimes a change of mouse pad or mouse causes the way your mouse responds to make it more difficult to use. You can change the speed of your mouse pointer to adjust for your individual set up. To do so in Windows XP:

* Go to Control Panel
* Select Mouse
* From the tabs on the top, select Pointer Options
* In the top box, titled "Select a pointer speed:"
* Slide the arrow along the continuum to the desired speed. (Slower or Faster)

Be sure "Enhance Pointer Precision" is checked.Adjusting the speed of your mouse pointer:

The ITDE office has written an application which should be used with county label generation for Cradle Crier and Toddler Tales mailings. The documentation for this document was revised in January.

To see the newest version of this document in PDF form, please go to: Cradle Crier/Toddler Tales Documentation

If you have the full version of Adobe Acrobat, you can create a new PDF from any document by printing to the Adobe PDF Driver from any application. Additionally, Acrobat installs some toolbar buttons in Microsoft Word which allow you to create a PDF from a document by clicking on the button. What's the difference between the two? See this blog entry: AdobePDF Print Driver vs 1-button PDF Creators: Which to use?

Allen Wyatt's Word Tips is a web page which offers information in a searchable format to answer common questions as well as "gotcha's" people encounter when using Word.

To access this site, go to: http://wordtips.VitalNews.com

This is IMPORTANT INFORMATION, and you will not have access to it if you are shut off from the Internet by UNH. For that reason, please print this out for future reference!

If UNH CIS detects unusual activity on your computer, they may shut you out of the network, in order to protect the other computers at UNH. When this happens, they only allow you access to a few sites, including theirs, Microsoft (for a Windows update), and McAfee for virus updates.

It is IMPORTANT to note that, while UNH uses McAfee for virus protection, UNHCE does NOT. We use Symantec/Nortons. The two antiviral packages conflict. Installing McAfee with a copy of Symantec/Nortons on your computer could render your computer useless. For that reason, it is important to use your copy of Symantec/Nortons to scan your hard drive, rather than use McAfee, as they recommend.

If you have been keeping up-to-date on Live Update, which is automated for most people, then your virus definitions may be fine. Double check with someone else in your office by looking at the date on your copy of Symantec/Nortons (Start\(all) programs\Symantec or Nortons, or use your Live Update or Nortons icon on your desktop.)

Compare the date on your version to someone who has completed a live update that day. If the dates are the same, your virus definitions are all set and can begin your scan. If not, you need to get a copy of Intelligent Updater, which can be downloaded from the Symantec site at: http://www.symantec.com/downloads/. That will need to be done on a computer which is connected to the Internet, burned onto a CD (it's too large for a floppy) and brought to your computer for installation. (The ITDE office can assist you with this step.)

Clicking on Intelligent Updater will start the update of your virus definitions. Once that is complete, you can do a scan of your hard drive.

Call the hot seat at:862-0351, if you need further assistance.

A new vendor, CompEd Solutions, will be offering a class in Advanced Excel in Manchester, NH on March 10, 2006.

The cost is $159 per person, but if you get a group of 4, the 4th person is free, making the net cost about $119 per person.

For a syllabus, to register or for further information, go to: http://www.nationalseminarstraining.com/Seminars/Advanced%20Training%20for%20Microsoft?%20Excel/1520517/index.html

A listing of all their classes can be found at: www.nationalseminarstraining.com

Note: They also offer a book title Excel Tips & Tricks with Chuck Chauvin for $99. See their site for further information.

The ITDE office has written an application which should be used with county label generation for Cradle Crier and Toddler Tales mailings.

To view this entire file in .PDF format, go to: Cradle Crier/Toddler Tales Documentation

Have you ever attempted to address something to someone who recently joined UNHCE, and been unable to locate the person in your address book? More than likely, that is due to not having the most recent version of the address book on your computer.

It is important to keep your Eudora address book up-to-date. It will give you access to addresses for all current users as well as current distribution lists.

The address book also contains useful information about the user's physical addresses, phone numbers, and listings of members of a distribution list. (See: http://extension.unh.edu/blogs/itde/archives/001412.html )

For information on updating your Eudora address book, go to: http://ceinfo.unh.edu/Intranet/ITDE/addres.pdf

Did you know your Eudora address book is more than a listing of email addresses? You can obtain information about people in our organization, along with other information, by using the Tabs in the Eudora address book. Here are two nice options:

Staff Addresses and Phone Numbers

A nice feature within the address book, is that you can obtain contact information on UNHCE staff, beyond just their email addresses. TO obtain this, first select the use. Then click on the "Info" tab for any user. That area will give you their physical address, phone number, and FAX number. It's a fast & easy way to get a directory information for UNHCE staff, and you don't even have to be on line to get it!

Who's on that distribution list?

The Notes tab is another useful feature. If you are wondering who is associated with a distribution list, select that distribution list, and click on the Notes tab. It will give you a listing of the people included in that distribution list.

Cache is a collection of web page copies stored on your computer's hard disk or in its random-access memory (RAM). The browser accumulates these copies as you browse the Web.

Sometimes, you need to clear your cache in order to view the latest version of a web page.

Clearing your cache in Netscape:

* Click on Edit
* Click on Preference
* Double Click on Advanced (so it expands)
* Click on Cache
* On the right you will see two buttons - clear disk cache and clear memory cache
* Click on both of them
* Click OK
* Close Netscape and then reopen

Clearing your cache in Internet Explorer

* Click Tools
* Click Internet Options.
* On the General tab, click Clear History
* Click OK
* Close IE and reopen

Tips and tutorial for repeating table headers across multiple pages in word procesing software can be found at:

* Repeating Table Headers (Microsoft Word XP)

* Repeating Table Headers (WordPerfect 10)

A note about distribution lists

UNHCE has distribution lists which are managed and updated by the ITDE office. These are for existing UNHCE groups, such as COAs. Most people, however, have groups of people to whom they frequently send email. Often times these lists include partners outside of UNHCE.

To create your own distribution list:

* Open the address book feature (Tools/address book, or click on the square box icon on your toolbar.)

* Select "New" at the bottom of the address book screen.*

* Enter a new nickname for your list. NOTE: (Be sure not to add it to the Staff Listing or Distribution Lists address books. These files are overwritten each time you update your address book).

* Enter the recipient addresses on the Address tab (one per line. )

* Click on the Info tab for the Nickname.

* Enter a name for the list in the Name field. (You can use the same name that you used for the Nickname or enter something different.) The name that you enter on the Info tab is the one that the recipients are going to see.

UNHCE system distribution lists can be downloaded by updating your address book. For further info, see: http://ceinfo.unh.edu/Intranet/ITDE/addres.pdf

A signature file can be added to the bottom of your emails to personalize your emails. Typically, a signature file includes your name and contact info, such as email address (alias), physical address, phone number, FAX number, etc. You can also include tag lines, if you'd like.


To activate a signature:

1. Select the Tools menu from the drop-down menus at the top of your Eudora application window.

2. Select options on the Tools drop-down menu.

3. Select "Sending mail" on the left side of the Tools\Options windowpane.

4. Select the desired signature in the default signature area.
Note: Clicking on the down arrow in that box will bring up a list of signature files

5. Click on OK to accept the change.

A signature file can be added to the bottom of your emails to personalize your emails. Typically, a signature file includes your name and contact info, such as email address (alias), physical address, phone number, FAX number, etc. You can also include tag lines, if you'd like.

To edit an existing signature block:

1. Select "Tools," from the drop-down menu at the top of the Eudora window

2. Select "Signatures" from the Signature window, Or click the Signature window’s tab if it is the inactive window in a tabbed group.

3. The Signatures windowpane will list all existing signatures

4. In the Signature window, right-click the signature and choose Edit from the context menu, or double-click the signature.

5. The signature window is displayed for that signature.

6. Make any changes you want.

7. Save the file with the File menu Save command

8. Close the window.

A signature file can be added to the bottom of your emails to personalize your emails. Typically, a signature file includes your name and contact info, such as email address (alias), physical address, phone number, FAX number, etc. You can also include tag lines, if you'd like.

To create a signature file in Eudora

1. Select "Tools," from the drop-down menu at the top of the Eudora window

2. Select "Signatures" from the Signature window, Or click the Signature window’s tab if it is the inactive window in a tabbed group.

3. The Signatures windowpane will list all existing signatures

4. Right-click anywhere inside the Signature window and choose New from the context menu.

5. Eudora displays the Create New Signature dialog, asking you for a name.

6. Enter a signature name in the dialog, and click OK.

7. A signature window is displayed.

8. Enter your signature text in the signature window. You can format the text
with styles: see Formatting Text .

9. Save the signature file using the File menu Save command.

10. Close the signature window.

Here is a SQL (mini-program you can write) for use with the Blue Ribbon software. It will allow you to cull the database for records of leaders with a certain # of years of service. In this example, we are looking for people with 20 or more years. For that reason, I put in the value of >19. You can adjust it according to your needs.

This one is written to be used with the state database. If you are using it with a county database, then you can skip the "countyID" field in the first line.

Select CountyID, Lastname, Firstname, City,Year4H, Category, Status
From Youth2a.db
Where ((Category = "R") or (Category = "P") or (Category = "G") or
(Category = "A"))
And ((Status = "N") or (Status = "R"))
And Year4H > "19"
Order by CountyID, LastName, Firstname

Note that SQLs can be adjusted, listing field names & values.

For further assistance with this process, please contact MarTech.

Word provides four different types of breaks that you can place within
your text. These breaks allow you to start new pages or new sections
in your document, as you require. This tip explains the differences
between each of the breaks supported by Word, along with how to insert
them in the document.

Read the full tip: http://wordtips.VitalNews.com/T0096

In some instances, Word may actually refuse to save any of your
AutoText entries in the Normal.dot template. There are a few things to
check if this happens, with the most likely culprit being a conflict
with Adobe Acrobat. This tip explains what you need to check.

Read the full tip: http://wordtips.VitalNews.com/T1712

Sometimes it is handy to know what style has been applied to
paragraphs. This is where the style area comes in really handy.
Turning on the style area is easy, provided you are viewing your
document in the proper way. This tip explains how to use the style
area.

Read the full tip: http://wordtips.VitalNews.com/T0189

You can use the Equation Editor to add complex equations to your
document. If the characters in the equation don't print out correctly
(but they display correctly), then there are only a few possible
causes. This tip explains a couple of things you can look for and
provides a resource you can use to track down additional information.

Read the full tip: http://wordtips.VitalNews.com/T1713

To print an Excel spreadsheet with (or without) gridlines:

1) Open the desired worksheet in Excel
2) Click on the file drop-down menu
3) Select Page Setup on the File menu
4) Select the Sheet tab on the top of the Page Setup menu
5) Select (or clear) the Gridlines check box
6) Print the worksheet with the revised setting

MarTech made an oversight when rewriting the software for this year. They added a drop-down selection box for the optional school code, but didn't give you a convenient way to add new school codes.

To add school codes to the School Master Code list, you need to first make that an option in the menu system. Page 2-14 in the User's Manual walks through the steps in customizing the menus, which can be used as a reference.

Here are the step-by-step instructions from MarTech for adding the School Code file to the File Menu:

1. On the opening screen in Youth Enrollment, two menu bars appear at the top of the screen. At the far right end of each bar is a small drop down arrow. On the second bar (the one with the colored icons), right click on the drop-down arrow.
2. A menu will appear. Select 'Customize'.
3.The Customize box will appear in the center of the screen. Select the 'Commands' tab.
4. On the next screen a 'Categories' and a 'Command' box will appear.
5. In the 'Categories' box, click on Files. The School Code file is a file option.
6. On the right side of the screen, under 'Commands' , scroll to the end of the list. You will see 'School Codes'.
7. Left click on 'School Codes' to grab it. Hold the mouse key down and drag the menu option to the upper-left corner of the main screen. As you hover over the word 'File', the File Menu will drop down.
8. I usually hang on to the 'School Code' option and move down the file list, dropping it at the bottom of the list.
9. The School Codes option is now on the File Menu. The file can be opened like any other master file. The question has come up as to what to do with leaders. I have suggested creating a school code as 'None' and using it for leaders. Counties have been very happy with this.
Please pass this information on to your counties. They may have the edit the School Code list as they are doing new enrollments for 2006.

Need to print out all the documents you have open? Word doesn't
provide a way to do this, but the macro in this tip will make short
work of the task.

Read the full tip: http://wordtips.VitalNews.com/T0166
Courtesy of: Allen Wyatt's WordTips

If you want to conserve paper and print documents very fast, then you
may want to use draft printing mode. You can invoke this printing
format by making one small change to the Options dialog box, as
described in this tip.

Read the full tip: http://wordtips.VitalNews.com/T0613
Courtesy of: Allen Wyatt's WordTips

Phishing is a techniques which utilizes the Internet to obtain personal information about you. It can be used to redirect your funds, steal your identity, and more.

ALWAYS be careful when entering credit card, banking, or personal account information over the web. Never enter information from a link provided in an unsolicited email unless you verify the source. "Phishermen" are resourceful at setting up sites which appear to be legitimate, yet your information is redirected to the spammer who "phishes" out your data.

For an article about it's risks and how to avoid it, go to: http://www.unh.edu/signals/october2005/phishing.htm

If you have a column of whole numbers in a table, and the negative
values have parentheses around them, then you may wonder how to best
align the numbers so they look professional in the table. This tip
explains a couple of different ways you can do the formatting.

Read the full tip: http://wordtips.VitalNews.com/T1704

Word allows you to format your text so it is justified, with each line
of a paragraph extending from the left margin all the way to the
right. At times this can cause your text to appear "choppy," with too
much space between some characters on the line. This tip explains how
you can minimize or reduce that choppiness completely.

Read the full tip: http://wordtips.VitalNews.com/T1703

One of the handiest shortcut keys in all of Word is Shift+F4.
Combining this shortcut with the Find feature allows you to quickly
and easily repeat your searches.

Read the full tip: http://wordtips.VitalNews.com/T0597
Courtesy of: Allen Wyatt's WordTips

The AutoComplete feature shows you suggestions based on the first few
characters you type in a word. The suggestion may be full dates, or it
could be AutoText entries, or any number of other helpful suggestions.
Word doesn't allow you to turn off just some of the many AutoComplete
suggestions you may see, but this tip discusses how you can still
access AutoText if you do decide to turn off AutoCorrect.

Read the full tip: http://wordtips.VitalNews.com/T1699
Courtesy of: Allen Wyatt's WordTips

The AutoCorrect feature of Word normally doesn't pay attention to
character case when kicking into action--if an entry is triggered by
"tww," it will also be triggered by "Tww" or "TWW." In most instances
this is not a problem, unless the uppercase version is really an
acronym that you don't want corrected to something else. This tip
discusses the workarounds you can use to get around this limitation.

Read the full tip: http://wordtips.VitalNews.com/T1698
Courtesy of: Allen Wyatt's WordTips

To change the text size in Netscape 7.0:

* Select View from the top menu bar

* Select Text Zoom from the drop-down menu

* Select the size (smaller, larger, or percent.)

For a tutorial on this topic, go to: http://cecf1.unh.edu/tutorials/tutorial.cfm?tut_id=21

Note: a listing of all the UNHCE on-line tutrials is available at: http://cecf1.unh.edu/tutorials/index.cfmtut_id=21">http://cecf1.unh.edu/tutorials

To display Web page text larger or smaller in Internet Explorer:

* Select the View menu from the top menu bar

* Point to Text Size

* Select the desired size.

Note: An on-line tutorial demonstrating this process, step-by-step, is available at: http://cecf1.unh.edu/tutorials/tutorial.cfm?tut_id=22

For a listing of ALL UNHCE on-line tutorials, go to: http://cecf1.unh.edu/tutorials/index.cfm

To change how Web page colors are displayed in Internet Explorer:

* Select the Tools menu from the top menu bar

* Click on Internet Options.

* On the General tab, click Colors.

*Change the settings as needed.

To display Web page text in a different font in Internet Explorer:

* Select the Tools menu from the top menu bar

* Click Internet Options.

* Select the General tab

* Click Fonts.

* In the Web page font and Plain text font lists, select the desired fonts

To change the font and font size in Corel WordPerfect 10

* Select File on the top menu bar

* Select document from the file dropdown menu

* Select Default font in the dialog box.

* Choose a font from the Face list.

* Choose a font size from the Size list box.

If you want to change the default font and font size for all new documents, click Settings, and click Set as default for all documents.

To change all text in an individual document, press CTRL + A to select all, prior to changing the font.

To change selected text, select the text prior to changing the font attirbutes.

Note: You must install a printer before you can change the default font.

Switching the primary button used on your mouse is helpful when wanting to switch from right-handed to left-handed use of the mouse (or vice versa.)

It is a good idea to alter your routine if you use the computer for extended periods of time. Changing the primary mouse button is one way to do that.

To change the primary button on the mouse, click on:

* The Start Menu (Lower left-hand corner of your screen)

* Settings (Windows 98 only)

* Control Panel

* Select mouse
Note: Do NOT choose Accessibility options

* Select the Buttons tab in the dialog box

* To make the Right button the one used for primary functions (such as clicking & dragging), check the box which says, "Switch primary and secondary
buttons."

* Click on Ok to save the changes.
Note: This change will take effect immediately. You need to use the newly selected option to click on Ok.

To reverse the process, deselect the "Switch primary and secondary buttons" box.

To change the default font in Excel, select the Tools option in the menu bar on top of the screen.

From the Tools dropdown menu, select:
* Options
* General
* Standard Font
* Select desired Font style and size

The changes will take effect AFTER you close and reopen Excel.

To change the font used in a chart in Excel:
Click the chart text, or select the individual characters you want to format.
If a chart title or text box is linked to a worksheet cell, you can change the formatting of all characters in the title or text box at the same time, but you cannot change individual characters.
To change the formatting for all of the text in the chart at the same time, click the blank area between the border of the chart and the plot area to select the chart area.

On the Formatting toolbar, click a button for the format you want.
To see other font options, such as superscript and subscript, click the text you want to change.
On the Format menu, click the command for the chart item you want to format ? for example, Selected Axis Title or Selected Object. (The name of the command depends on the chart item selected.)
Ten select the options you want on the Font tab.

To change the default font in Word:

Select the Format drop-down menu on the top of your Word application window

Select Font on the Format menu

Select the desired:
* Font
* Style and
* Size

Note that as you change your selections, the preview window within the dialog box allows you to see how the currently-selected font will appear.

Once you are happy with the selection, click on the Default Button on the lower left of the dialog box.

You will be prompted to confirm you want to change the default font for the active template. Click on Yes to complete the selection process.

Any new document you open will use the font settings you selected. It is not necessary to reboot.

Note: The default font applies to new documents based on the active template. Different templates might use different default font settings.

To change the font size or style in Eudora:

Click on the Tools dropdown menu on the top of your Eudora window.

Select:
* Options
* Scroll down the left menu bar in the Options window, and select "Fonts"
* On the fonts menu, select:
Screen (to change the font for messages you receive and are viewing)
Message (to change the font for a message you are creating)
or Print (to change the font for a hard copy of a message)

In each category you can change:
Size - and increase or decrease the font size as desired.
You can also change the default font style by selecting a different font in the font box.

This will affect the display in the next message you create or open. Rebooting is not necessary. (The mailbox listings will also change if you change if you change the Screen font.)

Selecting a theme allows you to change the colors & design of boxes on your desktop as well as in some of your applications.

This can be used to enhance visibility, select colors you desire, ease eye fatigue, or jazz up your desktop.

To change the theme click on:

The Start Menu (Lower lefthand corner of your screen)

Settings (Windows 98 only)

Control Panel

Display

Appearance (Windows 98)
Theme (Windows XP)

Select the theme

Note - there's a preview window so you can see what the theme will look like.

Click on OK to save the setting

In a recent tip, we showed you how to split your Word document
window by selecting Window | Split from the menu bar or by
double-clicking on the rectangle above Word's vertical scrollbar.
An astute Word Tips subscriber, Wendy Geddes, pointed out that
there is a way to split the document window without leaving the
comfort of your keyboard! Here's the new method. Press
[Alt][Ctrl]S ([command][option]S in v. X) to create a movable
horizontal line. Use the up and down arrow keys to move the line,
and press [Enter] when you've got it in the right place (not
available in v. X). The screen splits, and you can continue
editing your document. To remove the split, press [Alt][Shift]C
([command][option]S in v. X). Thanks, Wendy!
Courtesy of: Element K tips

To rearrange Internet Explorer's toolbars, click on the end of
any of the toolbars and hold down the mouse button while dragging
it to a new location. You can also shrink or enlarge the height
or width of a toolbar by hovering your mouse pointer over the
edge of a toolbar until it changes to a double-sided arrow. Then,
click and drag the edge closer to or farther from the opposite
side to change the toolbar's size. Finally, you can disable,
enable, or change what's available on any of these toolbars by
right-clicking on one and making the appropriate changes in the
resulting shortcut menu. You can also access this capability by
choosing View | Toolbars from the Internet Explorer menu bar.
Courtesy of: Element K tips

Instead of reaching for your mouse to click in your address bar
and type a new URL, press [Alt]D instead. This highlights the
current address in IE so that you can instantly type a new
address or paste a URL you've copied by pressing [Ctrl]V. In
addition, you can quickly move your cursor to different sections
of a URL by pressing [Ctrl][Left Arrow] to go back, or
[Ctrl][Right Arrow] to go forward.
Courtesy of: Element K tips

You can use outline numbering in a table, the same as you would
outside of a table. The only difference is the keystrokes you use to
change different outline levels. This tip discusses these differences.

Read the full tip: http://wordtips.VitalNews.com/T1678
Courtesy of: Allen Wyatt's WordTips

Microsoft has a Tips site on "How to Use Windows XP." It contains 365 tips for the average user. To access it, go to:
http://www.microsoft.com/windowsxp/using/default.mspx

Are you tired of pressing Tab at the beginning of a line, only to have
your whole paragraph indented? Change Word's behavior so that the Tab
key works like you expect it to.

Read the full tip: http://wordtips.VitalNews.com/T1147
Courtesy of: Allen Wyatt's WordTips

If you need to print a number of Word documents that reside in
the same folder, you can send them all to the printer in record
time. In fact, you don't even need to open the documents. Simply
press and hold the [Ctrl] key (press and hold [command][control]
in v. X) while selecting each file. (If your files are
consecutive, you can press and hold [Shift] while selecting the
first and last file.) Once you've selected all the files you want
to print, right-click one of the files and select Print from the
shortcut menu.

Courtesy of: Element K tips

In Excel 2002 you can now jazz up your headers or footers with
graphics. To do this, choose View | Header And Footer from the
menu bar. In the Page Setup dialog box, click either the Custom
Header or Custom Footer button. In the resulting dialog box,
click in the section where you want the graphic to appear (either
the Left, Center, or Right section). Then, click the Insert
Picture button. Locate and select the graphic file then click
Insert. You can also double-click on the graphic filename to
insert the graphic. Now, click OK twice to return to your
workbook.

Use Print Preview to see how the graphic looks on the worksheet.
To adjust the size or appearance of the graphic, open the Custom
Header or Custom Footer dialog box again. Place your insertion
point in the section that contains the picture placeholder,
&[Picture]. Then, click on the Format Picture button in the
dialog box to change the size, scale, or color of the image.
Click OK three times to return to your workbook.

Courtesy of: Element K tips

In previous versions of PowerPoint, you could only apply one
design template to a presentation. If you wanted to have more
than one, you had to jump through some hoops. Now, PowerPoint
2002 allows you to have multiple design templates within a
presentation. To apply a design template, first create the slides
with one design template. Then, to add another design template to
certain slides, in the Slide Pane select the slides that will
display the second template. You can hold down the [Ctrl] key and
click on non-adjacent slides. To select a group of adjacent
slides, select the first slide in the group, hold down the
[Shift] key and click on the last slide in the group. All the
slides in-between are selected. Then, apply a new design either
by clicking on the Design button on the Formatting toolbar, or by
right-clicking on a selected slide and choosing Slide Design. In
the Design task pane, select the template and it's applied to all
the preselected slides.

Courtesy of: Element K tips

Did you get a document from a co-worker or friend, and you want to
reset all the tab stops in the document? Doing so is easy if you know
the proper steps.

Read the full tip: http://wordtips.VitalNews.com/T1091
Courtesy of: Allen Wyatt's WordTips

Word allows you to add borders around paragraphs. For most people, the
distance between the border and the text in the paragraph is too
little. Here's how to control that distance very precisely.

Read the full tip: http://wordtips.VitalNews.com/T1669
Courtesy of: Allen Wyatt's WordTips

Word has had the ability to place tables within tables since the
release of Word 2000. This tip describes how you can best place tables
into a table cell and the best way to format the tables.

Read the full tip: http://wordtips.VitalNews.com/T1667
Courtesy of: Allen Wyatt's WordTips

One of the grammar tools provided in Word is a method to add
hyphenation to words appearing at the end of a line. This tip explains
how to perform both automatic and manual hyphenations of an entire
document.

Read the full tip: http://wordtips.VitalNews.com/T0616

Courtesy of: Allen Wyatt's WordTips

Do you need some information to appear left-aligned and right-aligned
on the same line? This tip describes how you can use tabs to
accomplish this formatting task.

Read the full tip: http://wordtips.VitalNews.com/T0623

Courtesy of: Allen Wyatt's WordTips

Word includes the ability to display toolbar icons in two sizes:
regular and large. You can turn on the large icons by using the
Customize dialog box, as described in this tip.

Read the full tip: http://wordtips.VitalNews.com/T0254

Courtesy of: Allen Wyatt's WordTips

Macros can be used to format portions of your document. In order to
format the right indent of a paragraph, you use the RightIndent
property. This tip explains how to use this property to get just the
indent you need.

Read the full tip: http://wordtips.VitalNews.com/T1144

Courtesy of: Allen Wyatt's WordTips

Do you need to save individualized copies of documents for a series of
individuals? This tip describes how to do just that, without using
mail merge. Individual names are pulled from a text file and placed in
the header of each document just before the document is saved.

Read the full tip: http://wordtips.VitalNews.com/T0464

Courtesy of: Allen Wyatt's WordTips

Source: Allen Wyatt's WordTips

Text is linearly spaced according to the specifications set up by the
makers of the font you are using. Word allows you to override the
spacing so that letters appear closer together.

Read the full tip: http://wordtips.VitalNews.com/T1137

Source: Element K Tips newsletter

Have you ever added an item to a list that has already been
formatted and then had to format the new item to match the
others? Excel 2002 can automatically format the new item using
the Extended Formats And Formulas option. For this feature to
work, at least three of the preceding five rows must have the
same format.

For example, let's say you have five items listed in cells A2
through A6. Format the items any way you want. In cell A7, type a
new item for the list. When you press [Enter], the new item is
formatted to match the preceding items.

This feature also copies down a formula if the preceding rows
contain the same formula. For example, suppose you have several
rows of data in columns B through G with column H containing a
formula at the end of each row. When you add a new row data to
the bottom of the list and press [Enter] for the last item of
data, the formula will be filled in the last cell for that row.

To turn this option on or off, choose Tools | Options from the
menu bar and click on the Edit tab. On the right side of the
dialog box, either select or deselect the Extend List Formats And
Formulas check box.

When you need to illustrate a point that words alone can't convey, pictures and tables can be a perfect complement to your document. However, pictures and tables can't always speak on their own; sometimes you'll need to discuss and refer to them within your document's text as well. When you use graphic objects to support your document text, it's a g