How to Delete Empty Rows on Google Sheets on Android

This wikiHow teaches you how to select and delete an empty row from a spreadsheet file on Google Sheets, using Android. Open Google Sheets on your Android. The Sheets app looks like a green document icon on your Apps menu. It will open up...

Steps

  1. How to Delete Empty Rows on Google Sheets on Android Picture 1How to Delete Empty Rows on Google Sheets on Android Picture 1
    Open Google Sheets on your Android. The Sheets app looks like a green document icon on your Apps menu. It will open up to a list of all your saved spreadsheet files.
  2. How to Delete Empty Rows on Google Sheets on Android Picture 2How to Delete Empty Rows on Google Sheets on Android Picture 2
    Tap the file you want to edit. This will open the spreadsheet in full-screen.
  3. How to Delete Empty Rows on Google Sheets on Android Picture 3How to Delete Empty Rows on Google Sheets on Android Picture 3
    Tap and hold a row number. Find the empty row you want to delete, and long-press the row number on the left-hand side of your spreadsheet. This will highlight the entire row, and open a pop-up toolbar above it.
  4. How to Delete Empty Rows on Google Sheets on Android Picture 4How to Delete Empty Rows on Google Sheets on Android Picture 4
    Tap the three dots icon on the toolbar. A new menu will pop-up.
  5. How to Delete Empty Rows on Google Sheets on Android Picture 5How to Delete Empty Rows on Google Sheets on Android Picture 5
    Select Delete on the menu. This will delete the entire row from your spreadsheet.
4.3 ★ | 4 Vote