How To Use Excel Drop Down List

Step 1 open the excel spreadsheet file you want to edit.

How to use excel drop down list. Make sure to enter each drop down entry in a separate consecutive cell in the same column. The following example shows you how to use excel formulas to create a variable drop down list. Unlock specific areas of a protected workbook or stop sharing the worksheet and then try step 3 again. In the source tab select the range of data for the drop down list. To achieve this right click on the sheet tab of sheet2 and click on hide.

To make your primary drop down list configure an excel data validation rule in this way. To create a drop down list in excel execute the following steps. If you don t want users to access the items on sheet2 you can hide sheet2. You ll want to select list in the drop down menu under allow. If you can t click data validation the worksheet might be protected or shared.

Go to the data tab on the ribbon then data validation. Again click on data validation. 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 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.

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. Now select the cell you want to apply the dynamic dropdown menu to and go to data data validation. The keyboard shortcut to open the data validation window is alt a v v. The spreadsheet below contains a list of members of staff. Under allow select list.

Select the cell in the worksheet where you want the drop down list. On the settings tab select list from the allow drop down list see drop down lists are everywhere. In the settings under allow click on lists. To create a drop down list start by going to the data tab on the ribbon and click the data validation button. The data validation window will appear.