How To Use Excel Drop Down List

Again click on data validation.

How to use excel drop down list. The keyboard shortcut to open the data validation window is alt a v v. On the second sheet type the items you want to appear in the drop down list. To achieve this right click on the sheet tab of sheet2 and click on hide. Go to the data tab on the ribbon then data validation. If you can t click data validation the worksheet might be protected or shared.

Step 1 open the excel spreadsheet file you want to edit. Now select the cell into which you want to add a drop down list and click the data tab. To make your primary drop down list configure an excel data validation rule in this way. You can position the drop down list in most any cell or even multiple cells choose data validation from the data ribbon menu. How to create a drop down data validation list.

A wizard box appears. Select list from field allow and within the source field write the new name of the table with as a prefix. If you don t want users to access the items on sheet2 you can hide sheet2. How to create a variable drop down list example. The data validation dialog box displays.

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. The data validation window will appear. To create a drop down list in excel execute the following steps. Unlock specific areas of a protected workbook or stop sharing the worksheet and then try step 3 again.

Select the cell in the worksheet where you want the drop down list. In the data tools section of the data tab click the data validation button. 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. The following example shows you how to use excel formulas to create a variable drop down list. 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.