Or, if you just want to insert your list in one specific cell, you can just click on that specific cell. If you want the same drop down list to show up in several different cells, you can click and drag to highlight all the cells you want it to be in. To create a drop down menu with options from a comma separated list, you’ll first need to select the cell(s) where you want the drop down list to appear. 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 |