how to create drop down list in google sheets

For On invalid data, select Show warning to warn the user if they enter something, not in the list, or Reject input to reject the entry entirely.Enable the checkbox for Show dropdown list in cell.Set the Criteria drop-down to List from a range, and select the field and select the entire list containing all of the data you want to be included in the drop-down list (in this case the range of ages).Select the Cell range field and select the range of cells under the Age column that you want to use this drop-down list.Here is how you need to set up the items in this window: This window is where you can define how your drop-down list will behave. This will open the data validation window. Then, select the Data menu and choose Data validation. Select the cell (in this case, Age) where you want to create your drop-down list. But, before you do this, you want to set up your drop-down lists. So a good first step is to hide these by hiding the columns. The problem with having these lists in the sheet is that everyone can see them. Type the contents of the drop-down lists in two columns. In this example, we’ll create drop-down lists for Age and Gender in a spreadsheet. How to Create a Drop-down List in Google Sheetsįirst, before you can create a drop-down list, you need to create the entries that will fill your drop-downs.

Let’s take a look at the process and how you can customize your drop-down list once you’ve created it. In the case of Google Sheets, you can pull in your drop-down list from a range of cells, or you can type in the full list separated by commas. But what if you use Google Sheets instead? To be honest, the process is even easier. Creating a drop-down list in Excel is fairly easy.

How to create drop down list in google sheets