Excel - Delete entire blank rows from Excel
Save time and efforts looking for entire blank or empty rows in excel sheet wherever they are on the worksheet, find and delete them by on click.
Three options to delete entire blank rows whether from selected range, current sheet or all sheets at once.
To start, go to Excel ribbon -> Dose.
1- In group Delete Rows click on Selection assuming you selected your data table or set then click on Entire Blank Rows. All blank rows found in your selected data will be removed and data will be relocated and arranged automatically.
2- In group Delete Rows click on Current Sheet then Entire Blank Rows. All blank rows found in your current active sheet data will be removed and data will be relocated and arranged automatically.
3- In group Delete Rows click on All Sheets then Entire Blank Rows. All blank rows found in your workbook will be removed and data will be relocated and arranged automatically.
The below image shows the Dose for Excel in the Excel ribbon:
 |
| Dose for Excel |
The below image shows the entire blank rows indicated by red arrows that will be deleted from excel sheet by one click:
Note: the row must be completely blank or empty, if a cell is filled in the row then it will
not be count as blank row and therfore will not be deleted.
Video Tutorial (Delete entire blank rows):
Visit our website at:
http://www.zbrainsoft.com/
See also:
