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\/3\/3e\/Sort-on-Google-Sheets-on-Android-Step-1-Version-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/3e\/Sort-on-Google-Sheets-on-Android-Step-1-Version-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-1-Version-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>"}
    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\/2\/2d\/Sort-on-Google-Sheets-on-Android-Step-2-Version-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/2d\/Sort-on-Google-Sheets-on-Android-Step-2-Version-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-2-Version-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\/4\/41\/Sort-on-Google-Sheets-on-Android-Step-3-Version-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/41\/Sort-on-Google-Sheets-on-Android-Step-3-Version-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-3-Version-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>"}
    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\/a\/a5\/Sort-on-Google-Sheets-on-Android-Step-4-Version-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a5\/Sort-on-Google-Sheets-on-Android-Step-4-Version-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-4-Version-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>"}
    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\/5\/5c\/Sort-on-Google-Sheets-on-Android-Step-5-Version-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/5c\/Sort-on-Google-Sheets-on-Android-Step-5-Version-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-5-Version-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>"}
    The filter toolbar will slide in from the bottom of your screen.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Sort-on-Google-Sheets-on-Android-Step-6-Version-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-6-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/3b\/Sort-on-Google-Sheets-on-Android-Step-6-Version-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-6-Version-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>"}
    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\/d\/d9\/Sort-on-Google-Sheets-on-Android-Step-7-Version-2.jpg\/v4-460px-Sort-on-Google-Sheets-on-Android-Step-7-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/d9\/Sort-on-Google-Sheets-on-Android-Step-7-Version-2.jpg\/aid9865549-v4-728px-Sort-on-Google-Sheets-on-Android-Step-7-Version-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>"}
    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
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Delete Google Photos and Keep Them on Your iPhone
      How to
      Sign Up for a New Google Voice Phone Number
      How to
      Disable Google Safe Search
      2 Simple Ways to Unsync Google Photos
      How to
      Restore Google Authenticator if You Lost or Reset Your Phone
      Dark Mode in Google Docs: Easy Steps for Desktop & Mobile
      How to
      Sign Out of Your Google Account on All Devices at Once
      2 Easy Ways to Permanently Delete (or, Hide) Your YouTube Channel
      Google Docs: 4 Ways to Delete Extra Pages in Your Document
      How to
      Use Google Translate: Complete Beginner's Guide
      How to
      Step Seeing Google Ads on PC or Mobile Devices
      How to
      Fix the "Google Play Store Has Stopped" Error
      Reverse Image Search in Google Lens: Android, iPhone, & Desktop
      5 Ways to Customize & Fix the Google Toolbar on Google Chrome
      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 36,192 times.

      Is this article up to date?

      Advertisement