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.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.