Article updated on April 10, 2018

The picture above shows data in column B, some cells contain nothing, they are blank.

I will now go through the steps on how to select cells containing data excluding blank cells and header cell.

  1. Select cell B3
  2. Press CTRL + SHIFT + END keys to select all values including blanks.
  3. Press function key F5
  4. Click "Special..." button located at the bottom left corner of the dialog box.
  5. Double click on "Constants"

This will select all cells that contain numbers, text, boolean and error values.

Note that cells containing a space character will be selected as well.