The fastest way to remove empty rows

Open your spreadsheet in Google Sheets and select all the data you want to clean. Click the Data menu, then choose "Create a filter." Small filter arrows will appear in the header row. Click the arrow in any column, scroll down to the bottom of the filter menu, and uncheck "Empty" — this hides all rows where that column is blank. Once you can see only the rows with data, select all visible rows, right-click, and choose "Delete rows." Then remove the filter by clicking Data and "Remove filter" again.

This method works because Google Sheets can hide empty rows temporarily while you delete the ones you want to keep. The filter does the hiding; you do the deleting. It takes about two minutes for a typical spreadsheet.

If your spreadsheet has only a few empty rows scattered throughout, you can also delete them one at a time: right-click the row number on the left side and choose "Delete row." This is slower but requires no menu navigation.

Key Takeaways

  • The filter method (Data > Create a filter, uncheck "Empty," delete visible rows) is fastest for spreadsheets with many empty rows mixed in with data.
  • You can delete single empty rows by right-clicking the row number and selecting "Delete row" without using filters.
  • Always remove the filter when you are done so your spreadsheet displays normally again.
  • Empty rows at the very end of a spreadsheet do not affect how the sheet works and do not need to be deleted.
  • Deleting rows in Google Sheets is permanent — you cannot undo it after closing the file, so double-check before you delete.

Why empty rows appear in your spreadsheet

Empty rows usually come from three sources: you deleted the data but left the row behind, you copied data from another file and some rows came along empty, or you added rows as placeholders and forgot to fill them in. Google Sheets does not automatically remove blank rows the way some other programs do.

Empty rows at the very bottom of your spreadsheet (after all your data ends) do not cause problems and do not need to be removed. They are just unused space. Empty rows in the middle of your data, though, can confuse formulas and make sorting behave unexpectedly, so those are worth cleaning up.

Using the filter method for large spreadsheets

The filter method works best when you have a spreadsheet with many rows and you are not sure which ones are empty. Start by clicking the cell in the top-left corner of your data — usually cell A1. Then click Data in the menu bar and select "Create a filter."

Small downward-pointing arrows will appear in the header row (the first row with column names). Click the arrow in the first column that contains data. A menu will open showing all the values in that column. Scroll to the very bottom of this menu. You will see a checkbox next to "Empty" — uncheck it. This hides every row where that column is blank. Click OK.

Now your spreadsheet shows only rows that have something in that column. Select all the visible rows by clicking the first row number, holding Shift, and clicking the last visible row number. Right-click and choose "Delete rows." Google Sheets will remove all the hidden empty rows at once. Finally, click Data and "Remove filter" to show your full spreadsheet again.

Deleting single empty rows manually

If you have only a few empty rows, you can remove them without using filters. Find an empty row by looking at the row numbers on the left side — an empty row will have no text or numbers in any of its cells. Click the row number itself (not a cell inside the row). The entire row will turn blue, showing it is selected.

Right-click the selected row number and a small menu will appear. Click "Delete row." The row disappears and all rows below it move up. Repeat this for each empty row you find. This method is slower than filtering but does not require you to remember menu locations.

What to do if you delete the wrong row

If you delete a row by mistake, press Ctrl+Z (or Cmd+Z on a Mac) when ready to undo. This works as long as you have not closed the file. Google Sheets keeps a history of your changes for about 30 days, so you can also click File, then "Version history," to see older versions of your spreadsheet and restore one if needed.

Once you close the file and reopen it, the undo history is gone. For this reason, it is worth taking a few seconds to look at a row before you delete it — make sure it is actually empty and not just hard to see because the text is white or the column is very narrow.

Preventing empty rows in the first place

You can avoid creating empty rows by being careful when you delete data. If you want to remove the contents of a row but keep the row itself, select the cells and press Delete — this clears the data but leaves the row. If you want to remove the row entirely, right-click the row number and choose "Delete row."

When you copy data from another spreadsheet or a website, paste it into a test area first and look for empty rows before you move it to your main data. Some sources add blank rows between sections, and catching them early is easier than cleaning them up later.

Frequently Asked Questions

Will deleting empty rows break my formulas?

Deleting empty rows will not break formulas, but it may change the row numbers that formulas refer to. If you have a formula that says "add up cells A1 through A50," and you delete row 25, the formula still works — it just now adds up rows 1 through 49 instead. Check any formulas that reference specific row numbers after you delete rows.

Can I delete empty columns the same way?

Yes. Use the same filter method but click the column letter instead of the row number. Select the column, right-click, and choose "Delete column." You can also delete columns one at a time by right-clicking the column letter and selecting "Delete column."

What if I have empty rows but they are not completely empty — one cell has a space or a formula that returns nothing?

The filter method will not hide these rows because Google Sheets sees them as containing data. You will need to delete these rows manually by right-clicking the row number. Alternatively, you can click each cell that contains only a space or empty formula, delete the contents, and then use the filter method.

Does Google Sheets have a button to remove all empty rows at once?

No built-in button exists, but the filter method is the closest thing — it lets you delete many empty rows in one action. The filter method is the fastest way to clean up a spreadsheet with scattered empty rows.

If I delete rows, does my spreadsheet file get smaller?

Deleting rows does not significantly reduce file size in Google Sheets. The file size is determined mainly by the amount of data and formatting, not by empty rows. Removing empty rows makes your spreadsheet cleaner and easier to work with, but it will not save storage space.