| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I copy a formula and the results copy from the original cell
I created a simple formula in a cell (D4+E4) and the result is, for example,
100. When I copy the formula into the line below the formula changes to (D5+E5), however, the result from the original formula, 100, copies into the cell instead of the result for the new row, say 74. I tried copy, paste special, formula, without success. Any help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I copy a formula and the results copy from the original cell
If the formula adjusted, but the result did not adjust then:
Tools Options... Calculate automatic -- Gary''s Student - gsnu200732 "brooklynsd" wrote: I created a simple formula in a cell (D4+E4) and the result is, for example, 100. When I copy the formula into the line below the formula changes to (D5+E5), however, the result from the original formula, 100, copies into the cell instead of the result for the new row, say 74. I tried copy, paste special, formula, without success. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy the formatted value and paste as a new value(not the original value with formatting)? | Excel Discussion (Misc queries) | |||
| How can I copy many formulas and keep original cell location? | Excel Discussion (Misc queries) | |||
| copy cell results and not underlying formulas | Excel Discussion (Misc queries) | |||
| How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
| Why does Excel Copy and Paste change dates from the original when. | Excel Discussion (Misc queries) | |||
Linear Mode
