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.
-
Select the cells that you want to contain the lists.
-
On the ribbon, select DATA and choose Data Validation.
-
In the dialog box, set Allow to List.
-
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."
-
Select OK.
Tip: You can also select a range in the sheet to use as a source for the drop-down-
Want more?
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.