This section contains the exact steps through which you can add a drop-down list in your Excel sheet in three different ways using data from the cells, doing it manually, or creating a dropdown list in Excel through the use of a formula. There are multiple methods to create a dropdown list in your MS Excel spreadsheet.

4 change the Allow: value to List from the drop-down list under Validation criteria section. 3 the Data Validation window will appear. Such as: B1 2 Go to DATA tab, click Data Validation command under Data Tools group.

Select a cell where we need to make the drop-down list. Auto Populate Cells Based on Dropdown Box Selection 1 select one cell that will be holding the drop down list. Its a great way to make the data consistent. We have a list of elements, as demonstrated below: 2. A Drop Down List in Google Sheets can be helpful when you want the user to select from pre-defined options. In the Data Validation dialogue box, within the settings tab, select вЂListвЂ™ as Validation Criteria. Go to Data > Data Tools > Data Validation.

Create a drop down list in excel