Fast way to select a range of cells

  1. Make the first cell current

  2. Press Ctrl + Shift + Down arrow to select cells containing values

The selection will stop at the next blank cell.

To navigate to the last cell value in a column