sequential formula copying
Rich
Sounds like Manual Calculation is set.
Go to ToolsOptionsCalculation and set to "Automatic".
Alternative..........the cell refs have been made Absolute by placing $ signs
like
=$F$1
Gord Dibben MS Excel MVP
On Thu, 2 Mar 2006 13:38:27 -0800, "arja"
wrote:
I'm trying to copy formulas down a column of many rows and I get the exact
formula in each copied row. I want the copied rows to refer to sequential
rows as F1, F2, F3, etc. What I get is every row refers to F1 which is the
original copy row.
Is this possible. TYIA
Rich
|