This is a surprisingly useful shortcut when you only have a few blank rows to remove. The problem is that this method selects blank cells, not blank rows. Power Query removes blank rows with a clean, repeatable processA reliable option for both one-off cleanups and recurring workflowsPower Query is one of the cleanest ways to remove blank rows in Excel. It also removes only completely blank rows, leaving records with individual blank cells intact. In Power Query, go to Home > Remove Rows > Remove Blank Rows.