A4 Accounting

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.