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.



Was this information helpful?

How can we improve it?

How can we improve it?

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

Thank you for your feedback!