Thread: Copying summed cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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?


Reply With QuoteReply With Quote