How to delete/change the formula of a cell and yet retain its cont
I think you want Copy,Paste Special--Values.
Test first!
"Hispanglo Sam" wrote:
I want to COPY a whole column of cells from a sheet where each cell in the
column is programmed =sum of previous row of cells, then PASTE the whole
column of results into another sheet where they will function simply as
starting values for a new calculation, i.e. without formula "=sum(a:b . . .)".
Problem: After pasting the column of cells into their new destination, I
don't know how to delete (or change) their now-inappropriate original formula
without losing their contents.
|