But if you’ve decided to use the selection of cells instead, you can click here to skip down to where I show you how to do that. But if you want to do something fancy with equations or you want to be able to easily change the options in the drop down menu, you might want to go with the range of cells.įirst, I’m going to show you how to use the comma separated list because that’s what I imagine most people will want to do. I would probably recommend using the comma separated list because it keeps your spreadsheet nice and tidy and really gets the list options out of the way. To create a drop down list in Google Sheets, the first thing you’ll need to do is decide whether you want the options in the drop down list to come from a range of cells on the spreadsheet, or from a comma separated list of items you’ve typed into a box. How To Make A Drop Down List In Google Sheets
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |