how to add drop down list in google sheets

Sometimes you may want to select an entire column if there’s a chance that your list might grow.

This needs to be checked if you want the list to be a dropdown.Ĭlick on “Save”, and you will now have an arrow in the corner of the cell.Ĭlicking on the arrow will open a dropdown list containing the list items from the range that you selected.Īnd it’s that easy! You can go back and change your range if you need to adjust the list. You can either type in the range of cells, or click on the grid to select the range.īelow this section is a check box to “Show dropdown list in cell”. This means that the list will come from a range of cells that you determine. There is a dropdown menu here, which has “List from a range” selected by default. Next, you need to tell it where the list is coming from. The first field is for the cell that has validation being applied to it (where your dropdown list will be). You could also right-click on the cell and select data validation from the pop-up menu. To create a dropdown list, you need to add data validation to a cell by clicking Data, then Data Validation. How to Create a Dropdown List From a Range This article shows you how to create a list from a range of cells. You can use dropdown menus to make sure people are only able to enter certain values into a cell, or you can use them to make your life easier when you’re using a cell to regularly check data in your spreadsheet. Creating a dropdown list in Google Sheets is very easy.

How to add drop down list in google sheets