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

  1. 1
    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.
  2. 2
    Tap the file you want to edit. Find the spreadsheet you want to edit on your saved files list, and open it.
    Advertisement
  3. 3
    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.
  4. 4
    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.
  5. 5
    Tap Create a filter on the menu. The filter toolbar will slide in from the bottom of your screen.
  6. 6
    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.
  7. 7
    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.
  8. Advertisement

About This Article

wikiHow Staff
Co-authored by:
wikiHow Staff Writer
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. This article has been viewed 20,868 times.
How helpful is this?
Co-authors: 1
Updated: May 15, 2018
Views: 20,868
Categories: Google Applications
Article SummaryX

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?
Advertisement