Forum Discussion
Delete Empty Rows Quick?
To quickly delete empty rows in Excel, select your data range (Ctrl + A), press F5 or Ctrl + G, click "Special," and choose "Blanks." This will highlight all empty cells. Right-click one of the highlighted cells, select "Delete," then choose "Entire Row" and click "OK" to remove all empty rows. And for activate Windows 11 pro , Microsoft partners like S2keys
Perfect, exactly what I needed, thank you.
For anyone worried this will delete rows with data, you can just select one column that will always have data in it, (id number, date eg) and you can still delete entire blank rows.
If you have varied data across rows and no column has no blanks, you can do a column with a COUNTA function and then replace all 0s with blanks, then use the above on the COUNTA column.