the data below it will be moved up. 5. Once all the blank rows are highlighted, go to the Home tab and find the "Delete" button on the right-hand side. Select "Delete Sheet Rows." This will remove ...