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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×