• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Entering Different Types of D... > Entering the Same Data Over and Over...

Entering the Same Data Over and Over with AutoComplete

When you type the first few letters of an entry, AutoComplete intelligently completes the entry for you based on the entries you've already made in that particular column. AutoComplete works with data entered in columns only, not rows. For example, suppose you want to enter the countries of origin for a series of packages. You type the name of a country once, and the next time you start to type that entry, AutoComplete inserts it for you.

By default, AutoComplete is always turned on, so you don't have to worry about that. However, if it drives you crazy, you can turn it off with the Tools, Options command. Click the Edit tab and click the Enable AutoComplete for Cell Valuesoption to turn it off.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint