How To Use Excel Drop Down List

The data validation window will appear.

How to use excel drop down list. Under data tab in the data tools section click on data validation. In the data tools section of the data tab click the data validation button. In the data validation dialog box do the following. Now select the cell into which you want to add a drop down list and click the data tab. On the data tab in the data tools group click data validation.

Unlock specific areas of a protected workbook or stop sharing the worksheet and then try step 3 again. 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. If you can t click data validation the worksheet might be protected or shared. To achieve this right click on the sheet tab of sheet2 and click on hide.

Select the cell in the worksheet where you want the drop down list. Now click ok and you re are done. Make sure to enter each drop down entry in a separate consecutive cell in the same column. Choose list from the allow option s drop down list. Now select the cell you want to apply the dynamic dropdown menu to and go to data data validation.

Step 1 open the excel spreadsheet file you want to edit. Select list from field allow and within the source field write the new name of the table with as a prefix. A wizard box appears. To create a drop down list in excel execute the following steps. Go to the data tab on the ribbon then data validation.

How to create a drop down data validation list. On the settings tab select list from the allow drop down list see drop down lists are everywhere. If you don t want users to access the items on sheet2 you can hide sheet2. To make your primary drop down list configure an excel data validation rule in this way. In the source tab select the range of data for the drop down list.