Skip to content

Data cleaning · Easy

How would you stop people entering bad data in a shared sheet?

Short answer

Use Data Validation to restrict entries to a list, number range or date range, with an input message and a clear error alert. Combine it with a structured Table, locked formula cells and sheet protection, so collaborators can enter data only where intended.

Detailed answer

Dropdown from a list: Data Validation › List › =Lists[status]. Keep the list in a Table so it grows automatically.