Data validation

Data Visualization in Google Sheets

Raina Hawley

Owner/Instructor of OzGrid Business Applications

Select dates from a list

Data Visualization in Google Sheets

Remove blank rows or columns

Data Visualization in Google Sheets

Format dates

  • Highlight the relevant range and select the Format tab
  • Ex: MM/DD/YY
  • Other options available
Data Visualization in Google Sheets

Format decimals

  • Decimals should be consistent
  • Spreadsheets round numbers with decimals
  • Highlight, select increase or decrease tool on toolbar
Data Visualization in Google Sheets

Creating the data validation

  • Under the Dates heading, select Data, Data validation
  • Use your Named range
  • "Show warning" to warn user of incorrect entry
  • "Reject input" to reject anything other than selection from list

Data Visualization in Google Sheets

Testing the list: reject input

Data Visualization in Google Sheets

Testing the list: validation help

Data Visualization in Google Sheets

Putting it into practice!

Data Visualization in Google Sheets

Preparing Video For Download...