How to Sort on Google Sheets on Android

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.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Sort-on-Google-Sheets-on-Android-Step-1.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-1.jpg","bigUrl":"\/images\/thumb\/4\/4d\/Sort-on-Google-Sheets-on-Android-Step-1.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The Sheets app looks like a white spreadsheet table on a green document icon. You can find it on your Apps menu.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Sort-on-Google-Sheets-on-Android-Step-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-2.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Sort-on-Google-Sheets-on-Android-Step-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Find the spreadsheet you want to edit on your saved files list, and open it.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Sort-on-Google-Sheets-on-Android-Step-3.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-3.jpg","bigUrl":"\/images\/thumb\/8\/82\/Sort-on-Google-Sheets-on-Android-Step-3.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Every column has a capitalized letter header at the top of your spreadsheet. Tapping it will select and highlight the entire column.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f1\/Sort-on-Google-Sheets-on-Android-Step-4.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-4.jpg","bigUrl":"\/images\/thumb\/f\/f1\/Sort-on-Google-Sheets-on-Android-Step-4.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This button is in the upper-right corner of your screen. It will open all your "Data" menu in a pop-up window.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/02\/Sort-on-Google-Sheets-on-Android-Step-5.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-5.jpg","bigUrl":"\/images\/thumb\/0\/02\/Sort-on-Google-Sheets-on-Android-Step-5.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The filter toolbar will slide in from the bottom of your screen.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/Sort-on-Google-Sheets-on-Android-Step-6.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-6.jpg","bigUrl":"\/images\/thumb\/f\/f5\/Sort-on-Google-Sheets-on-Android-Step-6.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This button looks like three horizontal lines in the lower-right corner of your screen. It will open your "Sort and filter" menu.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Sort-on-Google-Sheets-on-Android-Step-7.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-7.jpg","bigUrl":"\/images\/thumb\/8\/81\/Sort-on-Google-Sheets-on-Android-Step-7.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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
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
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Sign Out of Your Google Account on All Devices at Once
      How to Delete Google Photos without Deleting Them on Your Phone
      How to Disable Google Safe Search
      How to Sign Up for a New Google Voice Phone Number
      2 Simple Ways to Unsync Google Photos
      How to Restore Google Authenticator if You Lost or Reset Your Phone
      How to Use Google Translate: Complete Beginner's Guide
      2 Easy Ways to Permanently Delete (or, Hide) Your YouTube Channel
      How to
      Fix the "Google Play Store Has Stopped" Error
      How to Use Dark Mode in Google Docs: Easy Steps for Desktop & Mobile
      Reverse Image Search in Google Lens: Android, iPhone, & Desktop
      Easy Ways to Find Backed Up Photos on Google: 3 Methods
      How to Delete Duplicate Photos from your Google Storage
      How to Make a Free Website with Google Sites: Step-by-Step Guide
      Advertisement

      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?
      In other languages
      Thanks to all authors for creating a page that has been read 32,776 times.

      Is this article up to date?

      Advertisement