Excel, Delete blank rows without shifting data

microsoft excel

I want to delete blank rows, without shifting the data in anyway.

F5, Special, Blanks doesn't work as the cells as that deletes all blanks. Also doing a filter for blanks does not work.

Any other workarounds?

Blue is current, red is expected:

enter image description here

Best Answer

You can make it easier with a helper column.

Use e.g. this formula to mark rows with content:
=IF(COUNTA(A2:C2)>0,1,"")

enter image description here

Now you can select your helper column, F5 - special - check "formula" and unmark "number", this selects all the empty rows.
Just right click on one of them and delete - entire row.

Related Question