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

You can use a comma-delimited list, a cell range, or a named range to define the options in a drop-down list. This video focuses on how to use a cell range and named range.

Want more?

Create a drop-down list

Add or remove items from a drop-down list

Remove a drop-down list

Lock cells to protect them

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.