Excel will then highlight all of the blank ... go to the Home tab and find the "Delete" button on the right-hand side. Select "Delete Sheet Rows." This will remove the blank rows.