PC Review


Reply
Thread Tools Rate Thread

Copying summed cells

 
 
spitfiregp34
Guest
Posts: n/a
 
      21st Feb 2009
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?
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      21st Feb 2009

copy>edit>paste special>paste values
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"spitfiregp34" <(E-Mail Removed)> wrote in message
news:87DA2C30-E1A6-49C3-9BAF-(E-Mail Removed)...
>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?


 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      21st Feb 2009
Copy then paste special>values.

Now delete the original columns.


Gord Dibben MS Excel MVP

On Sat, 21 Feb 2009 07:50:01 -0800, spitfiregp34
<(E-Mail Removed)> 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?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying cells from on row in one wkbk to scattered cells in anthr Memphis Microsoft Excel Programming 1 10th Feb 2009 03:22 AM
show result of sum when summed cells are blank =?Utf-8?B?U2FyYWggKE9HSSk=?= Microsoft Excel Worksheet Functions 6 23rd Mar 2007 06:29 PM
adding summed cells in a conditional sumif =?Utf-8?B?VGF0?= Microsoft Excel Worksheet Functions 5 12th Jun 2005 06:09 PM
How do I see detail of summed cells =?Utf-8?B?R3JlZyBDaGFwbWFu?= Microsoft Excel Worksheet Functions 1 9th Nov 2004 08:43 PM
Find cells that summed up, equal a given value =?Utf-8?B?UnV6Z2Fy?= Microsoft Excel Misc 3 29th Mar 2004 06:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:35 AM.