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.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Step 2: Delete blank rows in Excel Now, you’re ready to delete the selected cells. Until now, I’ve used the term rows, but deleting the actual rows will delete everything in that entire row ...