BW Excel

In Excel, to select all cells in a column before the next blank cell, press ctrl+shift+down arrow.