How to Remove Empty Rows in Excel

Updated

Are you looking for a way to remove empty rows in Excel? Here’s a step-by-step guide on how to do it quickly and easily.

How to Remove Empty Rows in Excel

You can remove empty rows in Excel in a few different ways. The first way is to delete the rows manually. This can be done by selecting the entire row, right-clicking it, and clicking Delete>Sheet Rows. Even though you can select multiple rows with the CTRL or CMD key, this method can be time-consuming if you have a lot of empty rows. However, there is a clever workaround using the Go To function in Excel. Continue reading to learn how to remove empty rows in Excel.

How to Remove Empty Rows in Excel

To remove empty rows in Excel:

  1. Click on the button to the left of the A on the column row to select the entire spreadsheet.
  2. Hit CTRL+G (Windows) or CMD+G (Mac) to open the Go To window. You can also hit the F5 key.
  3. Click Special.
  4. Tick Blanks.
  5. Hit OK.
  6. Right-click a row and click Delete>Sheet Rows, or go to Home and click the arrow under the Delete button and click Delete Sheet Rows.

Now you know how to delete all your blank rows in one go! If you’d rather select each row manually, you can do that as well–it just may take longer.

How to Delete All Blank Rows in Excel in 3 Seconds

FAQ

How do you delete rows in Excel?

There are a few ways to delete rows in Excel. The most common is to right-click on the row number and select “Delete.”

Is there a shortcut to delete rows in Excel?

There is no shortcut per say, but you can use the Go To function to select specific rows that you want.

How do I remove blank spaces in Excel?

To remove blank spaces, hit CTRL+F or CMD+F. In Find what: put a space, in the Replace with: field don’t type anything. Then hit Replace All and all your blank spaces will be removed.

And now you know how to select all your blank rows and delete them quickly!

For more Excel walkthroughs, see our Excel Section.