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
• 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

How to Disable Background Printing in Word and on the Internet..

If you have applied background to your Word document but you do not want to show that in the printed copy of document – then disable the commands before you print.  And remember background printing uses additional system memory so to speed up printing, clear the Background printing check box.

To Disable background print in Word 97-2003

·         Go to Menu Bar, Tools, then click Options

·         Now click the Print Tab

·         Under printing options, select or clear the Background printing check box

·         When Background printing is on, you can continue to work in Word while you print,

To Disable background print in Word 2007

·         Click “Office” button > “Word Options”

·         Select “Advanced” tab

·         Then in right panel deselect check box for the option “Print in background” under Print section

·         Now click “OK”

To Disable background print in Word 2010

·         Click the File Tab, then choose options

·         Click on “Advanced” from left panel

·         Then in right panel deselect the check box followed by “Print in background” option under Print section and click “OK”

  

When you are on the Internet many websites have background colors or images that you might not want to print.  So, as with word, you may want  to disable the background printing..

To Disable background print when printing from a website on the Internet:

How to print from the Internet without backgrounds or images

·         Open a website that you to want to print out

·         In the Menu Bar go to Tools, then choose Internet Option

·         The Internet Options Dialog Box will now open

·         Click the advanced tab

·         Scroll Down and Find Printing section

·         Uncheck “Print background colors and images box

·         Hit OK or Apply button

Go to File, Print, Click Print (or simply use the Print icon on the toolbar)

Changing the default settings in your Office Programs

Default simply means “Standard” – the way in which a program will work each and every time you use it and you can change/modify many of the “default” settings on computer programs that we use daily, including our browsers and office programs…

This is a personal choice – certainly you can continue to use the default settings established by the provider that are built into the program.  But, changing the way your Browser or Office Programs work can make life so much easier.

Customizing your Office programs can impact the way in which documents print, how they are saved, the way they appear on the page, margins, paper layout/orientation – such as portrait or landscape, the font you use, whether the red & green squiggle lines appear as you type indicating spelling & grammatical errors - these are just a few of the many ways in which you can “customize” the way in which your Office Programs work for you.  Decide for yourself – making each program easier for you to use can be done as often as you’d like – some compare it to adjusting the seat position and rear view mirrors when you get into a car…

In Word 97-2003:

Click TOOLS, Then Click OPTIONS

You will see various options available for you to be able to modify to your liking

Click SAVE (set at 1 minutes – doesn’t affect your work, simply saves in the background)

Click SPELL (whichever options you’d like & Auto Text Entries and many others)

In Word 2007-2010:

Click on the Office Button or File Tab

At the bottom of the dialog box/page that opens, left click on “WORD OPTIONS”

This opens the Control/Dialog Box, which lists on the left various categories which allow you to “customize” the software you are using to your own liking..

Special Note for anyone using 2007-2010 Office Programs it is very important to save everything you do as “97-2003 compatible” so that you can share your documents with others who may not have the newest of these software programs.  You can do this as you save each and every document, or do it once when you are in your Options Settings, under the Save category..