| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete/change the formula of a cell and yet retain its cont
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Thanks!
So simple, but new to me. Just what I needed.
Thanks! "Toppers" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How delete formula bar and retain the computed number in a cell? | Excel Worksheet Functions | |||
| Need an expert . . . this is a toughy! ( cell links/format cont | Excel Discussion (Misc queries) | |||
| retain formula in additional workbooks | New Users to Excel | |||
| Can I retain a formula in the cell pasted to? | Excel Worksheet Functions | |||
| Is there a way to retain a formula while performing cut/paste? | Excel Worksheet Functions | |||
Linear Mode
