Getting rid of empty cells
 

I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting
and pasting. I have a lot of values and empty cells so if there is a formula
that would be a lot quicker than cutting and pasting. Thanks.

If the rest of the row is empty, why not just sort by blanks and delete en
masse?

--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a
way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with
cutting
and pasting. I have a lot of values and empty cells so if there is a
formula
that would be a lot quicker than cutting and pasting. Thanks.

Jam

Select A4, 5 and 6 then EditDeleteShift Up.


Gord Dibben Excel MVP

On Tue, 22 Feb 2005 05:41:06 -0800, Jambruins
wrote:

I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting
and pasting. I have a lot of values and empty cells so if there is a formula
that would be a lot quicker than cutting and pasting. Thanks.