To just delete the empty cells Select the range that has the empty cells
goto>edit>Go To>Special>Blanks>Ok. Now either right click or edit on the
tool bar and select "Delete", at the prompt select "shift cells up", and you
are done. I hope you realize that by doing this you will disrupt any
integrety the data may have. If there is no relationship with the data
between the columns or rows, then this will work. Make a copy of your data
first and see if it is REALLY what you want first.
Mike, I appreciate your getting back to me, I suppose I should have stated
the blank cells are in between cells with inforamtion. I am trying to find
a quick and easy way to highlight a range and delete only the blank cells
that are above and below filled cells. I just want to an easy way to get rid
of them without having to highligt every empty cell individually.
Mike, I appreciate your getting back to me, I suppose I should have
stated
the blank cells are in between cells with inforamtion. I am trying to
find
a quick and easy way to highlight a range and delete only the blank cells
that are above and below filled cells. I just want to an easy way to get
rid
of them without having to highligt every empty cell individually.
Click and hold your mouse on the first cell in the range and drag it to the
last cell in the range, then right click and choose delete/move contents up.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
