How can I delete all balnk cells in a column?
 

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?
--
Thank you

John

How can I delete all balnk cells in a column?
 

John

To just delete the empty cells Select the range that has the empty cells
gotoeditGo ToSpecialBlanksOk. 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

"John" wrote:

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?
--
Thank you

John

How can I delete all balnk cells in a column?
 

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
--
Thank you

John


"Mike Rogers" wrote:

John

To just delete the empty cells Select the range that has the empty cells
gotoeditGo ToSpecialBlanksOk. 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

"John" wrote:

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?
--
Thank you

John

How can I delete all balnk cells in a column?
 

John

Did you try my suggustion? It does what you asked.

Mike Rogers

"John" wrote:

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
--
Thank you

John


"Mike Rogers" wrote:

John

To just delete the empty cells Select the range that has the empty cells
gotoeditGo ToSpecialBlanksOk. 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

"John" wrote:

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?
--
Thank you

John

How can I delete all balnk cells in a column?
 

Do as Mike told you. That works fine.

Tyro

"John" wrote in message
...
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
--
Thank you

John


"Mike Rogers" wrote:

John

To just delete the empty cells Select the range that has the empty cells
gotoeditGo ToSpecialBlanksOk. 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

"John" wrote:

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?
--
Thank you

John

How can I delete all balnk cells in a column?
 

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.

"John" wrote in message
...
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
--
Thank you

John


"Mike Rogers" wrote:

John

To just delete the empty cells Select the range that has the empty cells
gotoeditGo ToSpecialBlanksOk. 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

"John" wrote:

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?
--
Thank you

John

How can I delete all balnk cells in a column?
 

To just delete the empty cells Select the range that has the empty cells
gotoeditGo ToSpecialBlanksOk.

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


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.