G
Guest
Hi
I'm trying to copy formulas across rows in a spreadsheet and getting a
result as if I am pasting the value but not the formula (which is not what
I'm doing)
I'm finding that even though the pasted formula reads as referring
correctly to the cells in the row that it's pasted to, the cell is showing
the value of the cell that I copied the formula from. I've tried doing
"paste special" and making sure that I'm copying the formula. I've also
tried the "formula auditing" function under the tools menu and it shows the
correct formula, and the correct values in the calculation, but then goes
onto give the value in the cell the formula's copied from. I'm completely
stuck. Can anyone help?
Many thanks
I'm trying to copy formulas across rows in a spreadsheet and getting a
result as if I am pasting the value but not the formula (which is not what
I'm doing)
I'm finding that even though the pasted formula reads as referring
correctly to the cells in the row that it's pasted to, the cell is showing
the value of the cell that I copied the formula from. I've tried doing
"paste special" and making sure that I'm copying the formula. I've also
tried the "formula auditing" function under the tools menu and it shows the
correct formula, and the correct values in the calculation, but then goes
onto give the value in the cell the formula's copied from. I'm completely
stuck. Can anyone help?
Many thanks