Automatic Drop Down List
Excel has a drop down list that is automatic. Check the image below
Things to note:
- Cell A1 is bold – that tells Excel its a column heading.
- I have entered two names, Fred and Mary
- In cell A4 when you use Alt + down arrow Excel automatically displays the list of the entries from above.
- You can use your arrow keys to select from the list and press Enter.
This feature is similar to another feature of typing f in cell A4 and Fred will appear in the cell as it matches the first letter from a word above.