Removing empty cells

Here are some options:

If there's nothing important to the right of the data range.
1) Select the data range
2) Turn on AutoFilter....this way:<data><filter><autofilter>
3) Click one of the drop-down arrows......Select: Blanks (at the bottom of the list)
4) Select the blank cells under the drop-down arrows.
5) Press the [Delete] key....(Autofilter only allows you to delete whole rows)
6) Turn off the autofilter....this way:<data><filter><autofilter>

or
1) Select the first column of the data range cells
2) [F5]....a shortcut for <edit><goto>
3) Click [Special]....Check: Blanks.....Click [OK]
....now all of the blank cells are selected
4)<edit><delete>....Check: Entire row.....Click [OK]

BUT....if you need the contents of the cells to the right of the data range to remain intact:
1) Select the data range
2) [F5]....a shortcut for <edit><goto>
3) Click [Special]....Check: Blanks.....Click [OK]
....now all of the blank cells are selected
4)<edit><delete>....Check: Shift cells up.....Click [OK]

Or
1) Insert a column before the data range
2) Put a 1 in the first cell of that column
3) Use one of the methods for creating a series of number (1 thru 10,000)
4) Select the data range (including the number series)
5) Sort the range by the 2nd column then by the 1st column (both Ascending)
...That will cluster all of the blank cells to the bottom
6) Select the range of blank cells.......<edit><delete>....Shift cells up....[OK]
THEN....
Sort again....by the 1st column only
...that will but the rows back in order

Do any of those methods help?