Download Article
Download Article
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
-
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 menu.
-
Tap the file you want to edit. Find the spreadsheet you want to edit 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.
-
Tap 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.
-
Tap Create a filter on the menu. 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.
-
Select 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.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
About This Article
Article Summary
X
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
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 36,593 times.
Advertisement