Google Sheets · Data preparation
Inspect blanks with a filter
Examine missing values before deleting anything.
Try it in three steps
- Select the data range including headers and all rows.
- Create a filter and show blank values in the target column.
- Inspect the visible records and document possible reasons for missingness.
How to read the output
Result: Records to investigate; filtering does not automatically clean data.
Test your understanding.
True or false?
Filtering blank values explains why those records are missing.
Related concepts
Official source
Google Sheets · Documentation ↗Documentation checked: . Steps are based on official documentation and have not been tested in the application. Menu names may differ by version and interface language.