Job Description Insert Dropdown List For Free

Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, then click Data Validation. On the Settings tab, in the Allow box, click List. If it's OK for people to leave the cell empty, check the Ignore blank box.

In a computer GUI, a drop-down menu is a menu that offers a list of options. The title of the menu, or the currently-selected item in the list, is always displayed. When the visible item is clicked, other items from the list "drop-down" into view, and the user can choose from those options.

Select the entire column you want to validate. Click on "Data Validation" from the Data tab. Choose "List" from the "Allow" box. Click on the arrow to the right of the "Source" box and select the cells containing the allowed values.

Dropdowns do have their advantages. First, they conserve screen space. Because they are a standard widget (even if an unpleasant one), users know how to deal with them. And, when used in forms and for attribute selection, dropdown boxes prevent users from entering erroneous data, since they only show legal choices.

Select the cell for your drop down list. Go to the Data tab then click on Data Validation to open the Data Validation dialogue box. In the Settings tab, select List under Allow. Click on the Source field. Click OK. (Image credit: Michelle Rae Uy)

A drop-down list (abbreviated drop-down; also known as a drop-down menu, drop menu, pull-down list, picklist) is a graphical control element, similar to a list box, that allows the user to choose one value from a list. When a drop-down list is inactive, it displays a single value.

In your document, place your insertion point where you want to add the drop-down list. Next, select the Developer menu. On the Developer menu, in the Controls group, click the Drop-Down List Content Control icon (It looks like an actual drop-down icon.). You now have a drop-down list in your document.