How to Remove Blank Rows in Google Sheets

By Gerard Fernandez · Updated · 3 min read

Imported data, pasted lists and old deletions leave gaps in a table. Blank rows break filters, charts and sorting, and deleting them one by one is slow. Here are three quick ways to get rid of them all.

Method 1: Sort the blanks to the bottom

Sorting always puts empty rows at the end, which is the fastest fix when row order doesn't matter.

  1. Select the table, including the header.
  2. Go to Data → Sort range → Advanced range sorting options, tick Data has header row, pick a column and click Sort.

The blank rows move below your data, where they no longer get in the way. See how to sort data for more options.

Method 2: Filter the blanks and delete them

This keeps your original order.

  1. Select the table and go to Data → Create a filter.
  2. Open the filter on a column that is always filled in real rows, for example Name.
  3. Click Clear, tick only (Blanks), and click OK. Now only the empty rows are visible.
  4. Select those rows by their row numbers, right-click and choose Delete selected rows.
  5. Go to Data → Remove filter. Your data is back, without the gaps.
Filter menu with Clear clicked and only (Blanks) ticked, above Ana, Ben and Cara
Real test: (Blanks) is the first item in the list.

We tried it on a list of 5 students with 2 empty rows in between. With only the blank rows showing, we selected them and used Delete selected rows. Only the visible rows were deleted: the hidden student between them, Cara, was still there after removing the filter.

The student list after deleting the blank rows and removing the filter: Ana, Ben, Cara, Dan and Eva with no gaps
Real test: after Remove filter, the five students are back with no gaps.

Watch out: a filter hides whole rows. Anything else in those rows, even in other columns outside the table, is hidden too while the filter is on.

Method 3: Build a clean copy with FILTER

To leave the original untouched and get a gap-free version elsewhere:

=FILTER(A2:C, A2:A<>"")
Student list with empty rows 4 and 6 in columns A and B; in E2, =FILTER(A2:B, A2:A<>"") lists the five students with no gaps
Real test: the original keeps its gaps (rows 4 and 6); the FILTER copy in column E has none.

This returns only the rows where column A isn't empty, and updates as the source changes: when we added a sixth student below, the copy picked it up immediately. See how to filter data for more conditions.

Rows that look empty but aren't: a cell with just a space isn't blank. If a row won't disappear, run Data → Data cleanup → Trim whitespace first.

Frequently asked questions

Will deleting blank rows break my formulas?

Formulas that refer to a range adjust automatically when rows are deleted. Formulas that pointed at a deleted row show #REF!, so check any that referenced the empty rows directly.

How do I delete blank columns?

The same way, sideways: select the empty columns by their letters, right-click and choose Delete columns.

Can I delete all rows below my data?

Yes. Click the first empty row number, press Ctrl + Shift + ↓ to select to the end, right-click and choose Delete rows.