Sort & filter your data

               

Want advanced Google Workspace features for your business?

Try Google Workspace today!

 

 

Sort your data

You can sort columns of cells alphabetically and numerically.

1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
2. To select a column, tap a letter at the top.
3. To open the menu, tap the top of the column again.
4. Tap More .
5. Scroll down and tap SORT A-Z or SORT Z-A. Your data will be sorted.

Filter your data

Tip: Filter views are only available on desktop.

Filters let you hide data you don't want to find. You can still find all your data when you turn the filter off.

Filter by values

1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
2. Tap More Create a filter.
3. Look at the column titles to find if filters have been applied:
   • Filter applied
   • Filter not applied
4. At the top of the column you want to filter, tap Filter .
5. The "Sort and filter" menu will open.
6. Tap Search .
7. Type in the search bar to find a value or scroll up on the list to find the values in the column.
8. Tap an item to uncheck it and filter it out. The sheet will update automatically.
9. To select all items, tap Select all. To deselect all items, tap Clear.

To turn off the filter, tap More Remove filter.

Filter by condition or color

You can also choose to filter data based on a condition. For example, you can choose to only filter items if the cell starts with a certain letter.

1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
2. Tap More Create a filter.
3. At the top of the column you want to filter, tap Filter .
4. Tap Filter by condition or Filter by color.
5. Tap the Down arrow and tap an option.
6. To save, go to the top left and tap Done .
7. Tap Filter Filter by condition Remove.

Related resources

• Use tables in Google Sheets
• Name a range of cells