PDF download Download Article PDF download 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.

  1. The Sheets app looks like a white spreadsheet table on a green document icon. You can find it on your Apps menu.
  2. Find the spreadsheet you want to edit on your saved files list, and open it.
    Advertisement
  3. Every column has a capitalized letter header at the top of your spreadsheet. Tapping it will select and highlight the entire column.
  4. This button is in the upper-right corner of your screen. It will open all your "Data" menu in a pop-up window.
  5. The filter toolbar will slide in from the bottom of your screen.
  6. This button looks like three horizontal lines in the lower-right corner of your screen. It will open your "Sort and filter" menu.
  7. 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

Expert Q&A

Ask a Question
      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.

      Is this article up to date?

      Advertisement