Video: Create a drop-down list

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

To make it easier to enter data in Excel, or to limit the entries in a cell to items that you define, you can Create a drop-down list. This list is compiled from valid entries you supply in cells elsewhere in the workbook. When you create a drop-down list in a cell, it displays an arrow in the cell that users can click to make a selection. Watch this short video to learn how to create your own drop-down list.

Applies To: Excel 2010

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