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

Chapter 25. Working with Lists and Datab... > Speeding Up Repetitive Data Entry wi...

Speeding Up Repetitive Data Entry with AutoComplete

Excel's default setup enables an option called AutoComplete, which is designed to speed up entering data in lists. As you type, Excel compares each character that you enter with other entries in cells directly above the active cell. If the opening characters match those of any other entry, Excel assumes that you want to repeat that entry and fills in the rest of the label. (This comparison applies only to cells that contain text; AutoComplete ignores numbers, dates, and times.)

If you want to repeat the previous entry, press Enter (or Tab or any arrow key) to insert the AutoComplete entry in the cell. Keep typing to enter a new value in the cell. Excel will not suggest an AutoComplete entry unless the string that you have entered identifies a unique entry in the list above the active cell.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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