How to make a drop down list in excel list in google sheets

The dropdown list should appear in the cell you entered in step 3.Add Help text and error information if you like and click РІР‚СљSaveРІР‚Сњ. Make sure that РІР‚СљShow dropdown list in cellРІР‚Сњ is checked.Manually select the data you want to appear inside the dropdown list here and click РІР‚СљOKРІР‚Сњ.Click on РІР‚СљSelect data rangeРІР‚Сњ or the little box icon to choose a range of cells.Next to РІР‚СљCriteriaРІР‚Сњ, you can filter РІР‚СљList from a rangeРІР‚Сњ and other options like.You can change the range here if you need to. If youРІР‚в„ўve highlighted the appropriate cell range this should automatically populate in the cell range section.

Click the Data tab and then Data validation, or right-click the selected cells and click Data validation.If youРІР‚в„ўd like to make the dropdown list in a single column or role click on the heading (Column A or Row 1 for example) and the entire section will become highlighted. Highlight the cells you want to include in the dropdown list by dragging the mouse or using Shift or Ctrl keys.Make a dropdown list in Google SheetsР”В¬reate a Sheet containing whatever data you need it to include. You can turn a simple spreadsheet into an interactive questionnaire, customer feedback form, or whatever you like with dropdown boxes as they allow dynamic input from whoever you allow access to. One of the more powerful spreadsheet tools is the dropdown box.

How to make a drop down list in excel list in google sheets