How to Add a Drop-down List in Excel

Date:2019-9-21 Author:Cordelia

You must have seen some Excel spreadsheets with drop-down list. It’s quite convenient to select an option from the list instead of typing it by yourself. Therefore, I’d like to share some experiences of creating a drop-down list in Excel.

1. Select the cell you want to add drop-down menu. Click Data Validation in Data tab.

This image has an empty alt attribute; its file name is 15697452481.png

2. In the Validation criteria section, choose List in Allow.

How to Add a Drop-down List in Excel

3. Input the text options of drop-down list in Source. Different options should be separated by half-angle comma like the picture below.

How to Add a Drop-down List in Excel

4. Hit OK and the drop-down list has been added to the cell you select.

How to Add a Drop-down List in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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