Copying summed cells

S

spitfiregp34

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?
 
G

Gord Dibben

Copy then paste special>values.

Now delete the original columns.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
List all tables, including document structure 0
Format column widths from one table to a separate table on same page 1
MS Project Center-Autolink column fields 0
Autonumber field in Excel that behaves the same as Access 0
sqlite-odbc write conflict 2
Two columns followed by single page-width column on same page 0

Top