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