Right-click one of the selected cells and then click Delete. In the window that opens, select either Shift cells up or Entire row. Shifting cells up will just remove the blanks from the range that you selected.