Download Article
Download Article
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.
Steps
Sorting a Sheet
Download Article
-
Open the Google Sheets app on your Android. 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.
-
Tap the file you want to edit. Find the spreadsheet you want to sort on your saved files list, and open it.Advertisement
-
Tap the header letter at the top of a column. Every column has a capitalized letter header at the top of your spreadsheet. Tapping it will select and highlight the entire column.
-
4Tap the header again to get a pop-up menu. The context menu will open so you can apply formatting and more.
-
5Tap the ⋮ icon. This three-dot menu icon stands for "More" and will show you more options.
-
6Tap 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
Sorting a Range
Download Article
-
1Open 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.
-
2Select the range you want to sort. 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!
-
Tap ⋮ . This three-dot menu icon stands for "More" and will show you more options for the data you selected.
-
Tap Create a filter . The filter toolbar will slide in from the bottom of your screen.
-
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.
-
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
Expert Q&A
Tips
References
About This Article
1. Open Google Sheets.
2. Tap a spreadsheet.
3. Tap a header letter at the top of a column.
4. Tap the " ⋮
" icon.
5. Tap Create a filter
.
6. Tap the Sort icon on the bottom-right.
7. Select A to Z
or Z to A
.
