Use the drop-down menu to select the education or qualification best demonstrated in each example.

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 clicks an arrow, and then clicks an entry in the list.

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

2. On the ribbon, click DATA > Data Validation.

3. In the dialog, set Allow to List.

4. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

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, click the DATA tab, and click Data Validation.

In the dialog, 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 click OK. The cells now have a drop-down list.

Up next, Drop-down list settings.

Lorem ipsum dolor sit amet, consectetur adipiscing elit.Morbi adipiscing gravdio, sit amet suscipit risus ultrices eu.Fusce viverra neque at purus laoreet consequa.Vivamus vulputate posuere nisl quis consequat.

Create an account