Excel formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I copy a cell with a formula to a new cell, the results are the same
in the target cell as it was in the source cell. It doesn't matter what the
values are in any cell.
 
The spreadsheet may be set to manual recalculation: press F9 to see if
you get the results you expect. If this is the case and you'd prefer
calculation to be automatic, click >Tools >Options and select the
Calculation tab; select Automatic.
 
Dave O said:
The spreadsheet may be set to manual recalculation: press F9 to see if
you get the results you expect. If this is the case and you'd prefer
calculation to be automatic, click >Tools >Options and select the
Calculation tab; select Automatic.

Thanks! that was the solution.
Click to expand...
 
Rolaxis said:
Whenever I copy a cell with a formula to a new cell, the results are the same
in the target cell as it was in the source cell. It doesn't matter what the
values are in any cell.
Click to expand...
 
Back
Top