How To Use Excel Drop Down List

The following example shows you how to use excel formulas to create a variable drop down list.

How to use excel drop down list. You can position the drop down list in most any cell or even multiple cells choose data validation from the data ribbon menu. The spreadsheet below contains a list of members of staff. Select a cell in which you want the dropdown to appear d3 in our case. Select the cell in the worksheet where you want the drop down list. Choose list from the allow option s drop down list.

To make your primary drop down list configure an excel data validation rule in this way. If you don t want users to access the items on sheet2 you can hide sheet2. If you can t click data validation the worksheet might be protected or shared. Now select the cell you want to apply the dynamic dropdown menu to and go to data data validation. On the second sheet type the items you want to appear in the drop down list.

In the settings under allow click on lists. Now select the cell into which you want to add a drop down list and click the data tab. You ll want to select list in the drop down menu under allow. In the source tab select the range of data for the drop down list. Under allow select list.

In the data validation dialog box do the following. Select list from field allow and within the source field write the new name of the table with as a prefix. The keyboard shortcut to open the data validation window is alt a v v. On the settings tab select list from the allow drop down list see drop down lists are everywhere. The data validation dialog box displays.

Step 1 open the excel spreadsheet file you want to edit. Now click ok and you re are done. A wizard box appears. The data validation window will appear. For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los.