Web select the cell where you want the list.

How to create drop down list in excel step by step. Adding form elements in excel 3. On the first sheet, select cell b1. On the ribbon, click the data tab, and click data validation.

Create a list of options. Web how to make an excel drop down list. Then, go to the data tab and click “data validation” in the data tools section of the ribbon.

Select one or more cells where you want the picklist to appear. Web step by step to create a form with drop down list in excel 1. Select the cells that you want to contain the lists.

We’ll firstly teach how to create a drop down list with a selection from the days of the week. Simply click the arrow and select an option. Web it’s easy and we’ll show you how.

In the first sheet, go to the data tools group under the data tab. On the second sheet, create the following named ranges. Create drop down list in the form 4.