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

What is a “Template” and how can you use them?

Basically "templates" are pre-designed layouts for various items you might want to create on your computer using the various Microsoft Office Programs...

Using TEMPLATES in Word, Excel, Power Point and other programs allows you to open a pre-designed document in these and other various programs.  You can then use the pre-designed layout which is stored in the “Template Folders”.  Some templates are built into your Office Program, and if you can’t find what you need, you can go to Microsoft online for even more templates, just as we do with clip art.  

This means you don’t have to create the entire document, form, spreadsheet/budget or other, power point presentation - much of the design work is already done for you.  Once you find a “template” you want to use, you save it in whatever folder you choose, you can modify it to your own needs and use it however you would like…It is yours.

In 1997-2003 Word/Excel/PowerPoint:

• Go to the Menu Bar, choose "New" and the Template Dialog Box will Open, which has multiple tab categories across the top
• Select the category you want, and you will see various template choices to choose from
• Select the template you want and it will be on  your screen
• Now save the template as your own, finding or creating a folder to save it in and giving it a name that works for you.
• Now you can modify it anyway you would like.

In 2007-2010 Word/Excel/PowerPoint:

• Go to the Office Button in 2007 or File Tab in 2010, Choose "New"
• You will now see the various templates available
• Select the template you want, and "download it"
• Select the template you want and it will be on your screen
• Now save the template as your own, finding or creating a folder to save it in and giving it a name that works for you
• Now you can modify it anyway you would like.

Printing Tips

TO PRINT A PORTION OF AN INTERNET ARTICLE OR EMAIL RECEIVED:

• Highlight the portion of the article or email you want to print
• Go to the Menu Bar or Office Bar and choose “Print”
• When the Print Dialog Box Appears, on the left side choose “selection”
• On the right side, choose the number of copies you want
• Choose OK and that is what will print..

TO ENLARGE THE PRINT SIZE OF A PORTION OF AN INTERNET ARTICLE OR EMAIL RECEIVED OR TO SAVE EITHER IN A FILE ON YOUR COMPUTER..

• Highlight what you want to copy & enlarge
• Give the command to copy (Go to Edit – choose Copy, Right Click on what you’ve highlighted & choose copy, or use the action key on your keyboard and choose copy)
• Open your Word processing program: Word, Word Perfect, Word Pad, Note Pad
• Put your cursor on the blank document when your WP program opens
• Activate paste (Go to Edit –choose Paste; Right Click on the document and choose Paste, or use the action bar on your keyboard and choose paste)
• What you copied is now on the document
• Highlight what you want to enlarge (to do the entire text – use the CTRL Key + A or go to Edit & choose “Select All”
• Once text is highlighted, change font size & text
• To print, Go to the Menu Bar or Office Button and choose “Print”
• When the Print Dialog Box Appears, on the left side choose “selection”
• On the right side, choose the number of copies you want
• Choose OK and that is what will print....

TO SAVE THIS NEW DOCUMENT ON YOUR COMPUTER IN A FOLDER:

• Go to the Menu Bar or Office Button and choose “Save As”
• When the Save As Dialog Box Appears, on the left side choose “My Doucments/Documnets”
• Choose or create the folder you want the document saved in
• Name the document at the bottom of the dialog box
• Choose OK and that is what will print....

TO PRINT TWO OR MORE PAGES OF A DOCUMENT ON ONE SHEET OF PAPER
PAGES:

• Go to the Menu Bar or Office Button and choose “Print”
• Under Zoom, click 2 OR more pages in the Pages per sheet box
• Choose OK and that is what will print

TERMS: MENU BAR, ACTION BUTTONS & TITLE BAR

Title Bar
Located at the top of the screen, your Title Bar always shows you where you are and what software program you are using. For example, when you open a new document, your Title Bar would display “Document 1 – Microsoft Word.” After you save the document the display will read (for instance) Weekly Schedule – Microsoft Word” – if you are visiting a webpage such as “All My Faves”, your Title Bar would display "All My Faves – Windows Internet Explorer".

Action Buttons
Located to the far right of the “Title Bar” there are three action buttons: minimize your screen ( - ), maximize your screen ([_]/Box ), or close/shut down the program ( X ).

Menu Bar
Located below the Title Bar, the menu bar allows you to access various menu selections by using your mouse and clicking. Certain commands & functions are always in the same "menu" such as you will always find Cut-Copy-Paste-Find-Replace in the Edit Menu..
Note: Newer versions of some software - such as Office 2007 & 2010 - no longer use the toolbar system with the Title & Menu Bars, but have replaced those with the newer Tab & Ribbon format...