Sorting Data in Google Sheets: Android Mobile Guide

Download Article

Sort columns or rows in Google Sheets on your Android device

Written by Darlene Antonelli, MA

Last Updated: July 7, 2025 Fact Checked

Download Article

Sorting a Sheet

|

Sorting a Range

|

FAQ

Did you know that you can sort numerically in Google Sheets on Android? That's right! The "A-Z" sorting option also sorts your data in ascending order, from lowest to highest; the "Z-A" sorting option reorganizes your data in descending order, from highest to lowest. Pretty neat, right? Read on to learn more about sorting in Google Sheets on Android.

Sorting Google Sheets on Android

To sort the entire sheet, tap on a column you want to sort by and tap it again to open a contextual menu, then tap the three-dot menu icon. Select "A-Z" or "Z-A" to sort your data. If you want to sort a range, select it and tap the three-dot menu icon, then tap Create a filter and apply a sorting option.

Section 1 of 3:

Sorting a Sheet

Download Article

The Sheets app looks like a white spreadsheet table on a green document icon. You can find it on your apps drawer by sliding up from the bottom of your screen or find the app icon on your home screen.
Find the spreadsheet you want to sort on your saved files list, and open it.

Advertisement
Every column has a capitalized letter header at the top of your spreadsheet. Tapping it will select and highlight the entire column.
The context menu will open so you can apply formatting and more.
This three-dot menu icon stands for "More" and will show you more options.
6
Tap Sort A-Z or Z-A. The column will immediately reorganize to show you the alphabetical list.
- The other columns in your sheet will sort along with the original column, so your data will not be broken up. ^{[1]
  X
  Research source}

Section 2 of 3:

Sorting a Range

Download Article

1
Open the document you want to sort in Sheets. You can find this app in your app drawer or by tapping the app icon on your home screen.
- Use this method if you only want to sort a specific range instead of the whole sheet.
Tap a cell and it will highlight. Drag that highlight to include every cell that you want to sort. Anything not highlighted will not change according to the sorting option, so be careful not to split your data!
This three-dot menu icon stands for "More" and will show you more options for the data you selected.
The filter toolbar will slide in from the bottom of your screen.
5
Tap the "Sort" icon. This button looks like three horizontal lines in the lower-right corner of your screen. It will open your "Sort and filter" menu.
- You can also tap the same icon in the first cell of the range you selected.
6
Select a sorting method. You can sort your column in alphabetical or reverse-alphabetical order. Selecting a method will reorganize and sort all the data in the selected column.
- If you select A to Z, the range will be sorted alphabetically.
- Z to A will sort the range in reverse alphabetical order.^{[2]
  X
  Research source}

Section 3 of 3:

FAQ

Download Article

1
Can I add filters to my view in Google Sheets? You can only add filters on desktop, not on Android. Check out this wikiHow article on how you can add filters on a desktop.
2
How do I sort numbers in Google Sheets mobile from highest to lowest? The "A-Z" sorting option organizes numbers in ascending order, like 1 to 10.
3
How do I sort numbers in Google Sheets mobile from lowest to highest? The "Z-A" sorting option organizes numbers in descending order, like 10 to 1.
4
Can I use Google Sheets on Android? Yes! The mobile app will open and edit XLS, XLSX, XLSM, CSV, ODS, and TSV files. If one won't open on mobile, open it on your computer instead (your phone may not have the available space or resources to load it properly)