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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |