To start filtering data in a spreadsheet highlight the fields in your dataset, and then click the Create a filter icon:
This feature can also be found/enabled by clicking on Data → Create a filter from the menu bar.
Google Sheets is typically intelligent enough to instrument filter capabilities atop your data fields, however we recommend highlighting them first to ensure proper placement.
Once the filter feature is enabled you'll notice three visual changes to your Google Sheet:
- The Create a filter feature will be compressed with a light green background
- The row and column indexes that are setup to be filtered will be highlighted in light green
- The fields capable of being filtered will have a filter icon in the cell (right aligned)
Clicking on a field's filter icon will pop a modal that allows you start filtering data in that field by one of two ways: Filter by Values, or Filter by Condition. For example, by clicking on the filter icon in the Getting Started, Users dataset User ID field:
Filter by values allows you to manually choose to include (checked) or exclude (unchecked) certain data points. Once a selection is made, hitting the "OK" button at the bottom of the modal will implement the filter.
Filter by condition opens up the ability to instrument an array of filters by use of conditional logic, and even an option to build your own Custom Formula filter.
Once a filter is instrumented on a field, the original three-line icon will convert to a filled filter icon. For example, here's a screenshot showing the User ID field filtered by values - 1, 2, 3:
Adding a filter to another filed follows the same process. For example, if we then filtered our three users by Country = 'United States', we'd get the following result:
Getting back to an unfiltered dataset is as simple as clicking back on the Create a filter icon, which will now have the annotation Turn off filter.