With AutoComplete, you can quickly fill in repeated entries in a column.
If the first few characters that you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you. Microsoft Excel completes only those entries that contain text or acombination of text and numbers; entries that contain only numbers, dates,or times are not completed.
To accept the proposed entry, press ENTER.
The completed entry exactly matches the pattern of uppercase and lowercase letters of the existing entries.
To replace the automatically entered characters, continue typing.
To delete the automatically entered characters, press BACKSPACE.
You can also select from a list of entries already in the column. To display the list, press ALT+DOWN ARROW to display the list, or right-click the cell, and then click Pick From List on the shortcut menu.