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

Use Word 2007 or 2010 to make Greeting Cards

Making greetings cards has never been easier than it is now if you have Word 2007 or 2010.

Whether you need a card for congratulations, new baby, get well or for any holiday imaginable, and both Word 2007 and 2010 have lots of templates to choose from – all of which you can modify for your very specific needs and occasion...

Reminder about Word 2007 & 2010: Office/Word 2007 uses an “OfficeButton” in the upper left corner; whereas Office/Word 2010 has gone back to the tab “File” the same phrase used in earlier versions of Word and other Office programs

• So in Word 2007, click on the Office Button – and in Word 2010, click on the File Tab
• Now Choose “New” and the New Document window will open.
• You will now see a vast variety of templates to choose from
• In Word 2007 it is a column list on the left side of the page
• In Word 2010 the bulk of the screen will show you various Templates
• Now choose Greeting Cards.
• You can choose the option you want from under the Greeting Cards section – check them all out and remember you can modify any of these to your liking for your specific needs
• You will be connected to the Microsoft Office Online site. You can select from hundreds of templates or you can go to this website in the browser and download the templates from there.
• You can preview every template in Word and then click the Download button
• The Office Genuine Advantage (OGA) validation dialog box will appear. (Once I’ve read this once, I click the check box in the bottom left corner asking that I not be shown the message again in the future) – I’ve heard, but it hasn’t happened to me, that you might have to download the updated version of OGA to be capable of downloading a template.
• You can customize the downloaded card by changing the colors, fonts etc or adding your message before printing it.
• Now you can print the card
• You can make your holiday and other greeting cards even more personal – just insert your own photos..

About the card stock: cards will always be more professional if when you use “greeting card paper stock” either 60 - 80lb. (versus standard 20lb. printer paper)

Many stores that carry computer supplies (such as Wal-Mart, Staples etc.) carry Card Stock paper and matching envelopes, and you can also find great deals online with companies such as:

www.desktopsupplies.com

www.thepapermillstore.com

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