20 November 18, 08:17
Quote:If you’re working with others on a shared Google Sheets file, sometimes people can enter unexpected data or something that breaks a formula. One way to ensure everyone enters the data you want is to provide it for them in a drop-down validation list.Full reading: https://www.howtogeek.com/395616/how-to-...le-sheets/
How to Create a Drop-Down List
A 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. It also provides a much faster way for people to input that data since they’re selecting from a pre-configured list you provide.
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.
RELATED: 5 Google Sheets Features You Should Know