How to Delete All Blank Rows in Excel? — HTuse

HTuse Excel · Jul 15, 2026

10 steps

How to Delete All Blank Rows in Excel?

Step 1

Select the range of data or the entire worksheet

Step 2

Press Ctrl+G or F5

Step 3

Click Special

Step 4

Select Blanks

Step 5

Click OK

Step 6

Right-click any selected blank cell

Step 7

Click Delete

Step 8

Choose Entire row

Step 9

Click OK

Step 10

Save the workbook