Data Validation

Data validation provides two benefits for data entry.

Ease of data entryDropdown menus display possible values.
Accuracy of dataPrevents typos, extra spaces, etc., that would otherwise prevent functions from properly identifying values.
    ➜ Try it
  1. Select column B, and choose Data ⇒ Data Validation.
  2. Enter Validation!B2:B40 for the criteria, and click Save.
  3. Repeat this for columns C and D.
  4. Select B1 through D1, choose Data Validation, and remove it from these cells.
  5. Repeat this for cells B3 through D3.
  6. Choose a location from the dropdown menu in cell C2 to see how much was spent there.