Copying summed cells
 

I am trying to copy a column of cells that I have summed from other columns.
I then want to erase the other columns, but then when I do this the copied
column all goes to zero. Is there a way to keep the values in the copied
column after I erase the original?

Copying summed cells
 

copyeditpaste specialpaste values
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"spitfiregp34" wrote in message
...
I am trying to copy a column of cells that I have summed from other
columns.
I then want to erase the other columns, but then when I do this the copied
column all goes to zero. Is there a way to keep the values in the copied
column after I erase the original?

Copying summed cells
 

Copy, then Edit/ Paste Special/ Values.
--
David Biddulph

spitfiregp34 wrote:
I am trying to copy a column of cells that I have summed from other
columns. I then want to erase the other columns, but then when I do
this the copied column all goes to zero. Is there a way to keep the
values in the copied column after I erase the original?

Copying summed cells
 

Copy then paste specialvalues.

Now delete the original columns.


Gord Dibben MS Excel MVP

On Sat, 21 Feb 2009 07:50:01 -0800, spitfiregp34
wrote:

I am trying to copy a column of cells that I have summed from other columns.
I then want to erase the other columns, but then when I do this the copied
column all goes to zero. Is there a way to keep the values in the copied
column after I erase the original?