View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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