Note: When you delete cells in Excel, the data below it will be moved up. 6. Once all the blank rows are highlighted, go to the Home tab and locate the Delete button on the right-hand side.