Sort & filter your data

You can sort and filter data in Google Sheets to organize and analyze it.

Note: Filter views are only available on a computer. See the FILTER article for info about the function.

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 More.
  5. Scroll down and tap SORT A-Z or SORT Z-A. Your data will be sorted.

Filter your data

Filters let you hide data you don't want to see. You can still see 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 More and then Create a filter.
  3. Look at the column titles to see if filters have been applied:
    • Filter applied filter applied
    • Filter not applied Filter
  4. At the top of the column you want to filter, tap Filter Filter.
  5. The "Sort and filter" menu will open.
  6. Tap Search Search.
  7. Type in the search bar to find a value or scroll up on the list to see 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 More and then Remove filter.

Use a conditional filter

Conditional filters let you choose which data to filter. 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 More and then Create a filter.
  3. At the top of the column you want to filter, tap Filter Filter.
  4. Tap No condition.
  5. Tap the Down arrow Down Arrow and tap an option.
  6. To save go to the top left and tap Done Done.
Was this helpful?
How can we improve it?