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.
-
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.
-
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.
-
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.
Written by:
wikiHow Technology Writer
This article was written by Travis Boylls. Travis Boylls is a Technology Writer and Editor for wikiHow. Travis has experience writing technology-related articles, providing software customer service, and in graphic design. He specializes in Windows, macOS, Android, iOS, and Linux platforms. He studied graphic design at Pikes Peak Community College. This article has been viewed 5,872 times.
Thanks to all authors for creating a page that has been read 5,872 times.
Google Sheets is Google's answer to Excel, helping you to create a multitude of spreadsheets within the Google Office Suite. When making a spreadsheet, it's important to be able to sort your data in different ways, depending on context, in order to help you make sense of it. For example, if you're making a spreadsheet to keep track of donations, sorting from highest to lowest or lowest to highest might be helpful. Spreadsheets aren't all about numbers, though. What if you want to keep track of something else, like people? In that case, it would be more helpful, perhaps, to sort alphabetically. Keeping track of people by first or last name from A to Z is one of the most common and familiar means of organization to most people — so if you're doing something like making a guest list or trying to keep track of preferences for a gift exchange, you'll probably want to sort out the names that way. Here's how to sort alphabetically in Google Sheets, on desktop and mobile. 1. Open Google Sheets on your PC or Mac computer. Log in and open the sheet that you want to sort. 2. Click and drag your mouse to highlight the data range you want to sort. 3. Click the "Data" button in the menu at the top of the screen. 4. In the dropdown menu, click "Sort Range." 5. In the pop-up window, be sure to specify whether or not your columns have headers. If they do, check the box at the top. 6. Select the column that you wish to sort alphabetically, then choose either A to Z or Z to A. 7. When you are sure everything is correct, click "Sort."
Choose a column to sort by and how to sort, then click "Sort." Melanie Weir/Business Insider
1. Open the Google Sheets app on your iPhone or Android.
2. Select the spreadsheet that you want to edit.
3. Tap the gray box in the top-left corner of the spreadsheet to select the whole document.
4. Click the three dots in the upper-right corner of your screen.
Select your data, then click the three dots in the top-right corner. Melanie Weir/Business Insider
5. In the side menu, tap "Create a filter."
Tap "Create a filter." Melanie Weir/Business Insider
6. Tap the green triangle next to the column you want to sort.
Tap the green triangle next to the column title or number. Melanie Weir/Business Insider
7. Under "Sort and filter," tap A > Z or Z > A.
Tap "A > Z." Melanie Weir/Business Insider
Melanie Weir
Freelance author
NOW WATCH: Popular Videos from Insider Inc.
Insider Inc. receives a commission when you buy through our links.