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.