Filtering Data
The next thing commonly done with datasets is to filter out the values you don’t want to see. Did you notice that some “Country Names” are actually not countries? You’ll find things like “World”, “North America” and “Arab World”. Let’s filter them out.
Walkthrough: Filtering Data
- Select the whole table.
- Select “Filter” from the “Data” menu.
- You now should see triangles next to the column names in the first row.
- Click on the triangle next to country name.
- You should see a long list of country names in the box.

- Find those that are not a country and click on them (the green check mark will disappear).
- Now you have successfully filtered your dataset.
- Go ahead and play with it – the data will not be deleted, it’s just not displayed.
