Video: Create a drop-down list

To make data entry easier in Excel, you can create a drop-down list in your worksheet. Watch this video to see how to use the data validation feature in Excel to create a drop-down list from a range of cells.

Demo button

Drop-down list in worksheet

Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language