| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula copies when only answer is wanted
Excel 2003, When I copy a group of cells with a formulas in them. The
formulas copy and try to adjust to match what they were before. I only want the sum of that solution to be copied. What am I missing? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula copies when only answer is wanted
If you want to copy the resulting values, rather than the formulae, use
Copy, then select the destination and use Edit/ Paste Special/ Values. -- David Biddulph "Rhino721" wrote in message ... Excel 2003, When I copy a group of cells with a formulas in them. The formulas copy and try to adjust to match what they were before. I only want the sum of that solution to be copied. What am I missing? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula copies when only answer is wanted
Thank you
"David Biddulph" wrote: If you want to copy the resulting values, rather than the formulae, use Copy, then select the destination and use Edit/ Paste Special/ Values. -- David Biddulph "Rhino721" wrote in message ... Excel 2003, When I copy a group of cells with a formulas in them. The formulas copy and try to adjust to match what they were before. I only want the sum of that solution to be copied. What am I missing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula help wanted | Excel Discussion (Misc queries) | |||
| Formula wanted | Excel Discussion (Misc queries) | |||
| Drag Formula copies values instead | Excel Worksheet Functions | |||
| Is There a Formula that copies another cell exactly in Excel? | Excel Discussion (Misc queries) | |||
| formula wanted please, I have a list of data | Excel Discussion (Misc queries) | |||
Hybrid Mode
