Automatic Drop Down List

Excel has a drop down list that is automatic. Check the image below

Tip_PickList

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.