Content

• To step
• Method 1 of 3: Delete individual rows
• Method 2 of 3: Using a filter
• Method 3 of 3: Using an add-on

This wikiHow teaches you three ways to delete empty rows in Google Sheets. You can delete empty rows by deleting them individually, using a filter, or with an add-on to delete all empty rows and cells.

To step

Method 1 of 3: Delete individual rows

1. Go to https://sheets.google.com in a web browser. If you are logged in to Google, you will see a list of Google Sheets documents associated with your account.
   • Log in to Google if you haven't already done so.
2. Click on a Google Sheets document.
3. Right click on the row number. Rows are numbered in the gray column on the left.
4. click on Delete row.

Method 2 of 3: Using a filter

1. Go to https://sheets.google.com in a web browser. If you are logged into your Google account, a list of the Google Sheet documents associated with your account will appear.
2. Click on a Google Sheets document.
3. Click and drag to select all of your data.
4. Click on the tab data. You can find this in the menu bar at the top.
5. click on Create a filter.
6. Click on the green triangle, consisting of three lines, in the cell in the top left corner.
7. click on Sort A → Z. This will move all empty cells down.

Method 3 of 3: Using an add-on

1. Go to https://sheets.google.com in a web browser. If you are logged into your Google account, a list of Google Sheet documents associated with your account will appear.
2. Click on a Google Sheets document.
3. Click on the tab Add-ons. You can find this in the menu bar at the top.
4. click on Add add-ons.
5. Type remove blank rows in the search bar and press ↵ Enter
6. click on + FREE. This button is located opposite "Remove Blank Rows (and more)". This add-on is depicted as an eraser.
7. Click on your Google account. If you have multiple Google accounts, you may be asked to which account you want to apply the add-on.
8. click on To allow.
9. Click the tab again Add-ons. You can find this in the menu bar at the top.
10. Select Remove Blank Rows (and more).
11. click on Remove rows / columns. This will open the add-on's options in a column on the right.
12. Click the gray, blank cell at the top left of the spreadsheet. This will select the entire spreadsheet.
    • You can also press Ctrl+a to select all.
13. click on Delete. This can be found in the add-on options for "Remove Blank Rows (and more)".