Using Auto Complete in Excel (and Word)

Auto Complete in EXCEL helps save time by reducing the amount of text we have to type (enter) when we are filling out a table with duplicate entries (like names, cities, states, and you can add more of your own... And this feature is also available in WORD.

 

By default, AutoComplete is turned on in Excel. These steps will first show you how to turn it off.

Turn AutoComplete On or Off in Excel 2010

• Click on the File tab of the ribbon to open the File menu
• Click on Options to bring up the Excel Options dialog box
• Click on the Advanced button in the left hand pane
• Under the Editing Options section
• Click on the Enable AutoComplete for cell values option box to remove the checkmark and Click OK
• AutoComplete should now be disabled
• To re-enable AutoComplete, re-check the option box

Turn AutoComplete On or Off in Excel 2007

• Click on Office Button > Excel Options to bring up the Excel Options dialog box
• Click on the Advanced button in the left hand pane
• Remove the checkmark from the Enable AutoComplete for cell values option box, Click OK
• AutoComplete should now be disabled
• To re-enable AutoComplete, re-check the option box

Turn AutoComplete On or Off in Excel 2003

• On the Tools menu, click Options
• Now  click the Edit tab.
• To allow automatic completion, click to select the Enable AutoComplete for cell values check box.
• To prevent AutoComplete click to clear the check box.
• AutoComplete should now be disabled
• To re-enable AutoComplete, re-check the option box

Word - How to Create NoteCards

For Word 2003:

For those of you with Word 2003, go to Menu Bar > Tools->Letters and Mailings->Envelopes and Labels. To do so:

1.      In Word for Windows, click the Labels tab

2.      From the menu next to "Label products:" or "Label vendors", choose the brand of your labels. Then, in the "Product number:" field, choose the label you need, for example:

ü         5315 for notecards

ü         5362 for nametags or badges

Note: If you wish to change margins or other settings, click New Label... . Enter a name for your custom label, and change the settings to your specifications. After you click OK, Word will show your label name in the "Product number:" field.

3.      Click OK to save your settings.

FOR WORD 2007/2010:

For those of you with Microsoft Word 2007 or 2010:

Open Microsoft Word 2007 OR 2010 and click on the "Microsoft Office Button" in the top left of the Ribbon.

1.          Click on "New" at the top of the menu.

2.          In the “New Document” dialog box, click on "More Templates" at the very bottom of the left task pane. In the middle task pane, click "Note Cards." The middle task pane changes to show a series of thumbnails for note card templates.

3.          Download the note card of your choice by double-clicking on the card thumbnail.

4.          Once you have downloaded the card of your choice it is yours – be sure to save it in a folder and name it as a “template”, so that as you make modifications you can then save it under the name of the event or person you are sending it to – but will have the blank original for future use

5.          You can make any modifications to the note card by clicking and typing text. You can also modify or delete graphics on the card by selecting the graphic to bring up the "Format" tab.

6.          Add clip art to your card by clicking on the "Insert" tab and then clicking "Clip Art" in the "Illustrations" group.

7.          When the task pane appears to the right of the screen, type an item to search for in the "Search For" field and click "Go." Add the graphic to your note card by double-clicking on the graphic.

8.          Click the "Microsoft Office Button" when you are done with your modifications. Click "Save" and give your note card document a name.

9.          Click the "Microsoft Office Button" and then "Print" to print out your note card.

 To print on both sides of a single sheet of paper check the "Manual Duplex" checkbox.

Word Processing-Tips to Create a Flyer or Invitation

BEFORE YOU BEGIN a new FLYER OR INVITATION

Be sure you have listed all information you need in your flyer and or invitation - It is too easy to forget something when you get busy “creating” so jot down the “5” W’s: 

Who - What - When - Where - Why

AS YOU BEGIN YOUR New Document:

Be sure to set your margins – If you are using paper with preprinted borders, measure the pre-printed area, so that you can set your margins allowing enough room so your typing doesn’t go into the printed border area (known as the gutter)

Once your margins (top, bottom, left & right) are set, then be sure to choose & set paper layout/orientation to either portrait or landscape

Name your NEW document:

Once margins & paper layout/orientation are set - now Name Your Document Immediately

·        When you open a document in Word, it will have a Document Number

·        The more “new documents you open” during the day the higher the numbers go

·        You want to name your document, so you can find it

·        In Word 97-2003, to the Menu Bar, File, Save As

·        In Word 2007, open the Office Button (Office Button replaced File in the upper left corner of monitor) and then choose Save As

·        In Word 2010, open File, Save As

*Note in Word 2007 & 2010 you want to be sure that you save all documents as 97-2003 compatible so that no matter what version of Word your friends or associates use, they will be open documents you send them and work with them…

Once you have chosen “Save As” the computer will open the “My Documents” folder in Word 97-2003, or in Word 2007/2010 it will open the Library First and then the Document master folder..

Once the Document master folder is open, choose or create the folder you want to save your work in; or if you intend to save yr work onto a flash or portable drive, go to My Computer, find the drive you are using, then open the Document master folder and then find or create the correct folder for your work to be saved in

Once you are in the specific folder you want your work stored in (Always look up to the top of the address bar in the Save As Dialog Box that your work will be saved in the correct folder you have chosen or created for it) you will now name your document

When you finish typing the document name, just use the enter key on your keyboard or you can left click on SAVE in the bottom right corner of the Save As Dialog Box

Tips:

• Type in all the information you will need on your flyer/invitation – do the formatting once the typing is done so you know how much data you have to work with
• Before printing the document on your pre-printed paper, print one on plain white paper & hold it against your paper to the light to be sure it is inside the border
• Have someone else read it, before your pint, so that you are totally sure you have included all of the information needed

Comparing two WORD documents side-by-side

If you have ever had two somewhat similar documents that you need to compare and merge the differences - here is how to do that easily... Since Microsoft Word 2003, all newer programs (Word 2001, 2007 & 2010) have a built-in document comparison tool where you can view two documents side-by-side.

1. Open both documents in Microsoft Word 2003, 2007 or 2010.
2. Focus on one document. Click on the Window menu bar option.
3. Click on Compare Side by Side With. If you only have two documents open, this menu item will mention the second document's filename. If not, a dialog box will appear allowing you to choose the document to compare.
4. The two documents will appear side-by-side. As you scroll through one document, the other will scroll as well.
5. A Compare Side floating toolbar will appear. If you don't want one document to scroll while the other scrolls, click the left button (it looks like two documents side-by-side with an up and down arrow).
6. View/edit your document as needed.
7. When done, click on Close Side by Side