Create a list of valid entries for the drop-down list, typed on a sheet in a single column or row without blank cells. Select the cells that you want to restrict data entry in. On the Data tab, under Tools , click Data Validation or Validate .

We can also use drop-down lists to create interactive reports and financial models, where results change when the user changes a cell’s value. How to Create a Drop-down (Data Validation) List. To create a drop-down list, start by going to the Data tab o

SEE: How to create a drop-down list in Google Sheets (TechRepublic) You can add the drop down list to multiple Excel cells. Select the range of data input cells (step 2) instead of a single Excel ...