EULA Insert Dropdown List For Free

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)

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.

Create a list of items that you want to displayed in your list box like in this picture. Click Developer > Insert. Under Form Controls, click List box (Form Control). Click the cell where you want to create the list box. Click Properties > Control and set the required properties:

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.

Select the cells that you want to contain the lists. On the ribbon, click DATA > Data Validation. In the dialog, set Allow to List. 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.

On the worksheet where you applied the drop-down list, select a cell that has the drop-down list. Go to Data > Data Validation. On the Settings tab, click in the Source box, and then change your list items as needed.

Right-click one of the cells you highlighted and click "Paste special." The Paste Special dialog box opens and displays several pasting options. Click "Validation" followed by "OK." Excel copies the drop-down list to the cells you selected.