J
John
I would like to go into a column, or onto a page and delete all the blank
cells. Is there a quick way to do this?
cells. Is there a quick way to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike Rogers
John
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 Rogers
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 Rogers
J
John
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.
If you know how please let me know.
John
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.
If you know how please let me know.
John
M
Mike Rogers
John
Did you try my suggustion? It does what you asked.
Mike Rogers
Did you try my suggustion? It does what you asked.
Mike Rogers
T
Tyro
Do as Mike told you. That works fine.
Tyro
Tyro
John said: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.
If you know how please let me know.
John
B
Bob
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.
last cell in the range, then right click and choose delete/move contents up.
R
Rick Rothstein \(MVP - VB\)
To just delete the empty cells Select the range that has the empty cells
An alternate to this is to select the range as above, then...
Edit/Find/Find All (leave Find What blank)/Ctrl A/Close
and then continue as below.
Rick
goto>edit>Go To>Special>Blanks>Ok.
An alternate to this is to select the range as above, then...
Edit/Find/Find All (leave Find What blank)/Ctrl A/Close
and then continue as below.
Rick