Q&A for How to Create a Drop Down List in Excel

Return to Full Article

Coming soon

Add New Question

Question

How can I add a drop down list, but not show all of the items in each row?

Community Answer

Separate the items in a more organized manner. Break down the items and add multiple entries.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 17 Helpful 16
Question

How can I add a dropdown box to multiple cells at the same time?

Community Answer

Copy the cell with the drop down list, highlight all the cells you wish to paste this to, select the paste special option and select "Validation" and then "OK."

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 8 Helpful 10
Question

I added a new field, but it is not appearing on the drop-down menu. How do I fix this?

Community Answer

Click on cell A1. Select the DATA MENU. Select DATA VALIDATION. In the VALUE field, select LIST, and in the SOURCE field, enter A,B,C.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 21 Helpful 15
Question

How do I create it to allow the user to add text?

Community Answer

Place a checkmark next to the field labeled "Ignore blank" if you want users to have the option of selecting zero items from the drop-down list when they use the spreadsheet.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 13 Helpful 4
Question

How do I add another item to my current drop-down list?

Community Answer

Simply add to the table that corresponds to your drop-down list and it's automatically inserted.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 7 Helpful 5
Question

How do I delete the tab where the list items are, since this will be a form used for work?

Community Answer

Simply right-click on the tab and name and select, "hide."

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 10 Helpful 1
Question

How do I protect the column so the user can only select from the drop-down menu?

Community Answer

Make sure that in the 'Error Alert' tab of the 'Data Validation' screen you have selected Style: 'Stop'. This enables the user to only select from the drop-down list.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 4