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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!