How to remove empty rows in a range (without VBA, without PQ, without formulae, even without the mouse)

 

Excel – How to remove empty rows in a range

 

The following technique explains, step by step, how to get rid of empty rows within a range.

Please note that this technique does not use either VBA, PQ or formulae.

It doesn't even use the mouse 😊