Microsoft Excel - How to Automatically fill in repeated entries in a column?

If the first few characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you. Excel completes only those entries that contain text or a combination 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.
• To select from a list of entries already in the column, right-click the cell, and then click Pick from List on the shortcut menu.