In this quick video tutorial, Excel Off The Grid explains how to harness the power of dynamic arrays, custom functions, and innovative Excel tools to eliminate blank rows without lifting a finger.

This example creates a helper class that allows you to select multiple data rows without pressing the CTRL key. Clicking on a data row toggles its selection state ...