This wikiHow teaches you how to delete blank rows in Google Sheets using three methods. You can remove rows by removing them separately using a filter, or an add-on that can remove all empty rows and squares.
Step
Method 1 of 3: Deleting Rows Separately

Step 1. Visit https://sheets.google.com via a web browser
If you're signed in to your Google account, a list of Google Sheets documents linked to your account will appear.
Sign in to your Google account if you haven't already

Step 2. Click the Google Sheets document

Step 3. Right-click the line number
Each row in the document will have a number in the gray column next to it.

Step 4. Click Delete Row
Method 2 of 3: Using Filters

Step 1. Visit https://sheets.google.com via a web browser
If you're signed in to your Google account, a list of Google Sheets documents linked to your account will appear.

Step 2. Click the Google Sheets document

Step 3. Click and drag the cursor to select all document data

Step 4. Click the Data tab
This tab is in the menu bar at the top of the page.

Step 5. Click Filters

Step 6. Click the green triangle icon with three lines in the top left corner of the box

Step 7. Click Sort A → Z
After that, all empty boxes will be moved to the bottom of the document.
Method 3 of 3: Using Add-ons

Step 1. Visit https://sheets.google.com via a web browser
If you're signed in to your Google account, a list of Google Sheets documents linked to your account will appear.

Step 2. Click the Google Sheets document you want to edit

Step 3. Click the Add-ons tab
This tab is in the menu bar at the top of the page.

Step 4. Click Get Add-ons

Step 5. Type Remove Blank Rows into the search bar and press Enter key

Step 6. Click + Free
This button is opposite the text "Remove Blank Rows (and More)". This add-on is indicated by an remover icon.

Step 7. Click Google account
If you have multiple Google accounts saved, you will be asked to select the account to add the add-on to.

Step 8. Click Allow

Step 9. Click the Add-ons tab again
This tab is in the menu bar at the top of the page.

Step 10. Select Remove Blank Rows (and More)

Step 11. Click Delete Blank Rows/Columns
Add-on options will appear in the right column of the page.

Step 12. Click the empty gray box in the upper-left corner of the worksheet
After that, all the columns and rows of the spreadsheet will be selected.
You can also use the shortcut Ctrl+A to select all content

Step 13. Click Delete
It's in the " Remove Blank Rows (and More)" add-on option.