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

Chapter 2. Entering Data into the Worksheet > Taking Advantage of AutoComplete

Taking Advantage of AutoComplete

Another useful feature that Excel provides to help take some of the drudgery out of entering information into a workbook is the AutoComplete feature. Excel keeps a list of all the labels that you enter on a worksheet by column. For example, suppose you have a worksheet tracking sales in Europe and you are entering country names, such as Germany, Italy, and so on, multiple times into a particular column in the worksheet. After you enter Germany the first time, it becomes part of the AutoComplete list for that column. The next time you enter the letter G into a cell in that column, Excel completes the entry as “Germany.”

You can also select an entry from the AutoComplete list. This allows you to see the entire list of available entries. Follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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