Choose your dojo

Master every interface, one skill at a time

Dropdowns & Checkboxes

What This Does

Data validation dropdowns restrict input to predefined options. Checkboxes give boolean columns for task tracking.

Why It's Useful

Free-text status columns become inconsistent—"Done", "done", "COMPLETE". Dropdowns enforce clean data.

How to Do It

  1. Select cells → Data → Data validation
  2. Criteria: List of items or range reference
  3. Insert → Checkbox for true/false columns
  4. Reject invalid input or show warning

Try This Now

Add a dropdown with three status options to a column.

Mental Hook: Pick from list, not free type.