how to delete blank rows in excel
Select the blank rows we want to delete. Hold Ctrl key and click on a row to select it. When the rows we want to delete are selected then we can right click and choose Delete from the menu.
Source: www.howtoexcel.org
how to remove empty rows in excel
block row from number column