What is Drop Down List
A drop-down list is a functionality in spreadsheets to choose a value to put in a cell from a list of multiple values. For example, you have a list of 10 products that you are selling. By using drop down list, you can choose any of the 10 products in a cell. It is useful for data analysis.
Process of Making Drop Down List
Follow these steps to make the drop-down list in Google Sheets.
- Prepare the item list in a range to populate in drop-down. (This is optional, you can directly type the items in the drop-down settings, without making the list in a range)
- Select the cell where you want to make DD list.
- Click on Data tab, then Data Validation.
- Click on Add Rule.
- In the Criteria, select either Dropdown or Dropdown (from a range)
- If Dropdown is selected, you have to fill the items in Option1, Option2…… If Dropdown (from a range) is selected, select the range where your items are.
- In the Advanced option, you can set up more things like the style of dropdown, what to do when invalid entry is done in the cell etc.
- After setting up everything, click on Done button.
After completing all above steps, a drop-down list menu will be created in the cell. By clicking on the drop-down arrow, you can select a value to be entered in the cell.
If this article is helpful, request you to share it. If you have any queries on this, please leave a comment. Thank You.
