How to Filter on Google Sheets on iPhone or iPad

Last Updated: May 25, 2021 Tested

This wikiHow teaches you how to use a filter on Google Sheets for the iPhone or iPad. Filters are a good way to sort and organize data in Google Sheets. You can create a filter to sort the order of rows or create conditional filters by settings unique rules to view your data in interesting ways.

Part 1

Part 1 of 3:
Creating a Filter

1
Open Google Sheets. It's the green paper icon with the 6 table cells in the middle.
2
Open the Google Sheet document.
3
Tap ⋯. It's the three-dot icon in the upper right corner.
4
Tap Create a filter. All cells that apply to the filter will be highlighted in green.

Part 2

Part 2 of 3:
Sorting the Filter

1
Tap the filter button in the top cell. It's the icon with the three vertical lines that form a triangle inside the cell.
2
Tap A→Z or Z→A to change the order data.
3
Tap a value on the list at the bottom. This will uncheck any values on the list. Any unchecked items will not be shown with the filter on.
- Tap the value once again to add it back to the list.

Part 3

Part 3 of 3:
Creating a Conditional Filter

1
Tap the conditions bar next to the settings icon. It currently should read "No condition".
2
Tap ▾ None. It's under the "Filter items if" heading. This will open a drop-down list with the condition options.
3
Select a condition to filter the data by. You can select:
- Cell is empty
- Cell is not empty
- Text contains
- Text does not contain
- Text starts with
4
Enter a value for your condition. For example, if you selected "Text starts with", you might enter "J" under to filter the list for the rows that have cells with text that starts with "J" in the selected column.
5
Tap the checkmark next to "Filter by condition". This applies the conditional filter. Only the rows with the conditions you specified will appear in the sheet.
6
Tap ⋯ and select "Remove filter" to stop using the filter.