How To Use Excel Drop Down List

In the data tools section of the data tab click the data validation button.

How to use excel drop down list. Select the cell in the worksheet where you want the drop down list. A wizard box appears. On the settings tab select list from the allow drop down list see drop down lists are everywhere. Select list from field allow and within the source field write the new name of the table with as a prefix. You can position the drop down list in most any cell or even multiple cells choose data validation from the data ribbon menu.

To make your primary drop down list configure an excel data validation rule in this way. To achieve this right click on the sheet tab of sheet2 and click on hide. If you can t click data validation the worksheet might be protected or shared. On the second sheet type the items you want to appear in the drop down list. If you don t want users to access the items on sheet2 you can hide sheet2.

If you are not familiar with drop down lists in excel you may want to first view the page on how to create a basic drop down list in excel. In the source tab select the range of data for the drop down list. Under data tab in the data tools section click on data validation. Go to the data tab on the ribbon then data validation. The data validation window will appear.

Under allow select list. The keyboard shortcut to open the data validation window is alt a v v. 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. In the settings under allow click on lists. To create a drop down list in excel execute the following steps.

Now click ok and you re are done. In the data validation dialog box do the following. The following example shows you how to use excel formulas to create a variable drop down list. How to create a variable drop down list example. You can find and double click a saved excel file on your computer or open microsoft excel and create a new worksheet step 2 enter the list of values for your drop down in a column.