Data validation

When other people type into your sheet, data validation keeps the inputs clean. Select a range, then go to Data › Data validation.

You can require a number in a range, a valid date or email, or an item from a dropdown list. Choose Reject input to block bad entries, or Show warning to flag them.