Create and manage drop-down lists

Drop-down lists

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.

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

Data entry is quicker and more accurate when you use a drop-down list to limit the entries that people can make in a cell.

When you select a cell, the drop-down list’s down-arrow appears, click it, and make a selection.

Here is how to create drop-down lists: Select the cells that you want to contain the lists.

On the ribbon, select the DATA tab > Data Validation.

In the dialog box, set Allow to List.

Click in Source.

In this example, we are using a comma-delimited list.

The text or numbers we type in the Source field are separated by commas.

And select OK. The cells now have a drop-down list.

Up next, Drop-down list settings.

Need more help?

Want more options?

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

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.