Easily remove or delete all blank rows in Excel

Deleting blank or empty rows from large datasets can be very time-consuming in Excel. Some users might select each blank row individually and then delete them one by one. Here the Delete Blank Rows utility of Kutools for Excel can help to easily remove all blank rows in a range, the current worksheet, specified worksheets, or an entire workbook with a single click.

Delete or remove all blank rows from a range

Delete or remove all blank rows from active worksheet, selected worksheets or whole workbook

 Select Kutools > Delete > Delete Blank Rows. See screenshot:

Delete or remove all blank rows from a range

Suppose you have a range with blank rows in a worksheet, as shown in the screenshot below. To remove all these blank rows at once, you can use the Delete Blank Rows feature as follows:

1. Select the range of cells from which you want to remove blank rows, go to select Kutools > Delete > Delete Blank Rows > In Selected Range.

2. A Delete Blank Rows dialog box pops up, you need to choose one of the following options based on your needs.

• Delete Blank Rows in the Range
  If there has data in the same rows outside the selected range and you don't want to affect these data, choose this option. Blank rows within the selected range will be removed, and data within the selection will be shifted up without affecting the data outside the selection.
• Delete Entire Rows with Blank Cells in the Range
  If this option is selected, the entire row with blank cells will be deleted (including the data in the same rows outside the selected range).
  
  

Result

Delete or remove all blank rows from active worksheet, selected worksheets or whole workbook

If you want to remove all blank rows from the active sheet, you just need to select Kutools > Delete > Delete Blank Rows >In Active Sheet. See screenshot:

Then all blank rows in the active sheet will be removed.

Notes:

Demo: Quickly remove or delete all blank rows from a range, worksheet, whole workbook