How To Delete Empty Rows in Google Sheets

Google Sheets is a very easy program to use and to learn. It allows you to create, access, and edit a spreadsheet through your Google account. As long as you have internet access, you can manipulate your Google Sheet to make data tables, produce charts, etc.

When you open a new Google Sheet, it opens with 1,000 rows and hundreds of columns. Most likely you will not need every row and column the default setting gives you. Once you are done creating and editing your sheet, you may want to delete the empty rows. You can do this one row at a time, but it will take you a while and is not a very efficient use of your time. Below there are two different ways to delete empty rows.

Filter Empty Rows and Delete Them

The easiest and most efficient way to delete empty rows is to put a filter on your sheet and delete them all at once. You can place a filter on your sheet based on many different criteria. Filtering for blank cells or rows is on the criteria. When you filter for the empty rows and delete them, it won’t delete any of your rows that are not part of the filter.

  1. Select the entire Google Sheet. You need to select the whole thing or else the filter will not work.
  2. Click on the Data tab at the top of the sheet.
  3. A drop-down menu will appear.
  4. Click on Create Filter. This will add filters to the headers of your sheet.
  5. Click on the filter icon in any of the columns of your sheet. The filter icon looks like an inverted pyramid in the right corner of your header cells.
  6. Another drop-down menu will appear. Click on the blue Clear. This will deselect all the filter options.
  7. Click on the Blank option then click Ok.

When you have done this you will have a filtered sheet that only shows the empty rows. All the other rows will be hidden. You can now select all the empty rows and delete them.

  1. Click on the column number into the left of the row.
  2. Hold the shift key and then click the last empty row in your sheet. This will select all the empty rows shown on your sheet.
  3. Right-click on any of the row numbers.
  4. Click the Delete Rows Number-Number. In your menu, it will have actual numbers.
  5. Click on the filter icon.
  6. Click the Turn off Filter. This will unhide the other rows in your sheet.

Sort the Data and Delete Empty Rows

You can also delete empty rows by sorting your data and deleting the rows. However, this is not a very good way to do it. Once you have sorted the rows and deleted the blank ones, it can be difficult to put your data back the way it was.

  1. Select the entire sheet.
  2. Click on the Data tab at the top of the sheet.
  3. Click on Sort range by Column A, Z-A. All of your empty rows will be at the bottom of the sheet now.
  4. Click on the column number into the left of the row.
  5. Hold the shift key and then click the last empty row in your sheet. This will select all the empty rows shown on your sheet.
  6. Right-click on any of the row numbers.
  7. Click the Delete Rows Number-Number. In your menu, it will have actual numbers.

Deleting rows from Google Sheets is easy to do. There are a few ways to do it, but you need to understand which will be the best for you and your information.