Filtering a Spreadsheet
Open your dataset
![](https://s3.amazonaws.com/media-p.slid.es/uploads/314969/images/5400191/Screen_Shot_2018-10-23_at_1.21.03_PM.png)
We'll use data about manumissions of enslaved people in Albany, courtesy of the Albany County Hall of Records
"Data" > "Create a Filter"
![](https://s3.amazonaws.com/media-p.slid.es/uploads/314969/images/5400195/Screen_Shot_2018-10-23_at_1.21.13_PM.png)
Filter using the small toggle on each column
![](https://s3.amazonaws.com/media-p.slid.es/uploads/314969/images/5400200/Screen_Shot_2018-10-23_at_1.21.30_PM.png)
Filters can be used to:
- Get an overview of your data
- Sort alphabetically or by date
- Filter out blanks or irrelevant records
- Get only records for a specific range
- Create a new dataset
![](https://s3.amazonaws.com/media-p.slid.es/uploads/314969/images/5400211/crop.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/314969/images/5742893/Screen_Shot_2019-02-03_at_4.53.05_PM.png)
Not all Blanks are irrelevant!
Hint: To avoid having to uncheck every option you don't want, use "clear" or "select all"
![](https://s3.amazonaws.com/media-p.slid.es/uploads/314969/images/5742949/Screen_Shot_2019-02-03_at_5.09.23_PM.png)
You can also use a filter to do a text search. How many women were identified as someone's wife?
-
What's the date range of our data?
-
What's the geographic scope? What towns are represented?
-
What's the problem with the place names?
-
Are there any patterns in the manumissions of children?
-
(Hint: Filter "Slave First Name" by condition "Cell is not empty" and "Child Name" by "Cell is not empty" and try to interpret the results)