Easily remove or delete all blank rows in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
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:
- To remove all blank rows from certain worksheets, you need to manually select the worksheets one by one by holding the Ctrl key and then select Kutools > Delete > Delete Blank Rows > In Active Sheet.
- To remove all blank rows from the entire workbook, please select Kutools > Delete > Delete Blank Rows > In All Sheets.
- After applying the feature, if blank rows still exist, you need to check if there is a space or other invisible characters in the cells of the row.
- This feature supports Undo (Ctrl + Z).
Demo: Quickly remove or delete all blank rows from a range, worksheet, or whole workbook in Excel
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs ā no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010ā2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 ā 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
