3 Ways to Delete Blank Rows in Google Sheets on PC or Mac Computer

2024 Author: Jason Gerald | [email protected]. Last modified: 2023-12-16 10:50

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.