Data Validation in Spreadsheets

Summary

Restricting what can be entered into a cell (dropdown lists, number ranges, custom rules) to prevent bad data from entering a shared spreadsheet in the first place.

• 1Add a dropdown list data validation rule to a sample input sheet.
• 2Set up a custom validation rule (e.g. only allow numbers within a range).
• 3Learn why this matters most for spreadsheets multiple people manually update.