Select the range of cells
Press Ctrl+G or F5
Click Special
Select Blanks
Click OK
Right-click any selected blank cell
Choose Delete
Select Shift cells up or Entire row
Click OK
To delete blank rows, filter for blanks and delete the visible rows
To remove blanks from a column, use Go To Special and delete the selected blank cells
To remove blank spaces in text, use the TRIM function
To remove nonprinting characters, use the CLEAN function