Focing a cell to be used
 

Is it possible to keep a cell used when you drag an equation to multiple cells?
1200*a1^(b1)
1200*a2^(b1)
..
..
..
1200*an^(b1)
the way it stand now, draging the equation leads to both cells roaming. I
want to fix one cell. The question is how.

Focing a cell to be used
 

Use an absolute reference. Where you now have b1, use $b$1.
(There are also mixed references. $b1 would keep the column fixed as you
copy across; b$1 would keep the row fixed as you copy down).

"NAUBryan" wrote:

Is it possible to keep a cell used when you drag an equation to multiple cells?
1200*a1^(b1)
1200*a2^(b1)
.
.
.
1200*an^(b1)
the way it stand now, draging the equation leads to both cells roaming. I
want to fix one cell. The question is how.