![]() ![]() List From a Range: A list of values that have been selected from other cells in the same or a different sheet.Next, open the “Data” menu and select the “Data Validation” command.įrom the Criteria drop-down, choose either “List From a Range” or “List of Items.” RELATED: 5 Google Sheets Features You Should Know The first thing you need to do is open up your Google Sheets file and select the cell(s) for which you want to use a drop-down list. It also provides a much faster way for people to input that data since they’re selecting from a pre-configured list you provide. How to Create a Drop-Down ListĪ drop-down list is a great way to ensure the data people enter into your form, application, or spreadsheet is exactly what you’re expecting. One way to ensure everyone enters the data you want is to provide it for them in a drop-down validation list. If you’re working with others on a shared Google Sheets file, sometimes people can enter unexpected data or something that breaks a formula. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |