This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The wikiHow Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 20,868 times.
Learn more...
This wikiHow teaches you how to select an entire column in a Google Sheets spreadsheet, and sort all the data in alphabetical or reverse-alphabetical order, using Android.
Steps
-
1Open 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 menu.
-
2Tap the file you want to edit. Find the spreadsheet you want to edit on your saved files list, and open it.Advertisement
-
3Tap 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 ⋮ icon. This button is in the upper-right corner of your screen. It will open all your "Data" menu in a pop-up window.
-
5Tap Create a filter on the menu. The filter toolbar will slide in from the bottom of your screen.
-
6Tap 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.
-
7Select a sorting method. You can sort your column in alphabetical or reverse-alphabetical order. Selecting a method will re-organize and sort all the data in the selected column.
- If you select A to Z, the column will be sorted alphabetically.
- Z to A will sort the column in reverse-alphabetical order.
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.