5 Simple Steps to Delete Rows on Google Sheets on Android

PDF download Download Article
Easy-to-follow steps to remove rows on Google Sheets from your Android
PDF download Download Article

This wikiHow teaches you how to select and remove an entire row on Google Sheets, using Android.

Things You Should Know

  • Open your spreadsheet in Sheets on your Android.
  • Tap and hold a number next to a row.
  • Tap "Delete" to get rid of that row.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8e\/Delete-Rows-on-Google-Sheets-on-Android-Step-1.jpg\/v4-460px-Delete-Rows-on-Google-Sheets-on-Android-Step-1.jpg","bigUrl":"\/images\/thumb\/8\/8e\/Delete-Rows-on-Google-Sheets-on-Android-Step-1.jpg\/v4-728px-Delete-Rows-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 Google Sheets app looks like a six-column, white table on a green sheet icon on your Apps menu.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Delete-Rows-on-Google-Sheets-on-Android-Step-2.jpg\/v4-460px-Delete-Rows-on-Google-Sheets-on-Android-Step-2.jpg","bigUrl":"\/images\/thumb\/8\/82\/Delete-Rows-on-Google-Sheets-on-Android-Step-2.jpg\/v4-728px-Delete-Rows-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 file you want to edit on the list of your saved spreadsheets, and open it.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/23\/Delete-Rows-on-Google-Sheets-on-Android-Step-3.jpg\/v4-460px-Delete-Rows-on-Google-Sheets-on-Android-Step-3.jpg","bigUrl":"\/images\/thumb\/2\/23\/Delete-Rows-on-Google-Sheets-on-Android-Step-3.jpg\/v4-728px-Delete-Rows-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>"}
    Find the row you want to delete, and long-press the row number next to it on the left-hand side of the sheet. This will highlight the entire row. Your options will pop up on a toolbar.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/aa\/Delete-Rows-on-Google-Sheets-on-Android-Step-4.jpg\/v4-460px-Delete-Rows-on-Google-Sheets-on-Android-Step-4.jpg","bigUrl":"\/images\/thumb\/a\/aa\/Delete-Rows-on-Google-Sheets-on-Android-Step-4.jpg\/v4-728px-Delete-Rows-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>"}
    It's on the right-hand side of the toolbar. Tapping will open a list of all your options.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d8\/Delete-Rows-on-Google-Sheets-on-Android-Step-5.jpg\/v4-460px-Delete-Rows-on-Google-Sheets-on-Android-Step-5.jpg","bigUrl":"\/images\/thumb\/d\/d8\/Delete-Rows-on-Google-Sheets-on-Android-Step-5.jpg\/v4-728px-Delete-Rows-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>"}
    This will delete the entire selected row.
    • All the rows below the deleted row will be shifted upwards on your spreadsheet.
    6. 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

      Thanks to all authors for creating a page that has been read 36,923 times.

      Is this article up to date?

      Advertisement