Deleting blank rows in Excel

Can I delete blank rows in Excel?

Yes, highlight the cells that you want to remove the blank rows from.

• Press F5 on your keyboard.
• Choose Special
• Select Blanks
• OK - this will select all the blank rows
• Select Edit, Delete Cells, Entire Row