Sign in

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.