| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
copying formulas to another cell
when i copy a formula to another cell it does it correctly, but it also shows
the same value from the copied cell. |
|
#2
|
|||
|
|||
|
What? Can you be more specific? Post the formula and an example of the cells
contents. "greg" wrote: when i copy a formula to another cell it does it correctly, but it also shows the same value from the copied cell. |
|
#3
|
|||
|
|||
|
I resolved the problem. In tools, options there is a tab called calculation.
If it's set on manual, you have to input formulas into each cell. If automatic is check marked the formula will copy correctly. My problem was the formula and the value in the cell would paste into the new cell "Julieeeee" wrote: What? Can you be more specific? Post the formula and an example of the cells contents. "greg" wrote: when i copy a formula to another cell it does it correctly, but it also shows the same value from the copied cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas within Cell References | Excel Discussion (Misc queries) | |||
| Excel: hold a reference to a single cell when copying formulas? | Excel Worksheet Functions | |||
| Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
| Formulas appear in cell instead of formula result | Excel Worksheet Functions | |||
| Excel & Copying Formulas | Excel Worksheet Functions | |||
Hybrid Mode
