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: