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

Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection.

Create a drop-down list

You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet selects an arrow, and then selects an entry in the list.

  1. Select the cells that you want to contain the lists.

  2. On the ribbon, select DATA and choose  Data validation buttonData Validation.

  3. In the dialog box, set Allow to List.

  4. Select the Source field and type the text or numbers for the drop-down list, separate by commas. For example, "Yes,No,Maybe" or "True,False."

  5. Select OK.

Tip: You can also select a range in the sheet to use as a source for the drop-down-

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.