Increment one column but keep the other constant

[dongwi]

Here is what I try to do:
At
A1 = Power(C1,B1)
A2 = Power(C2, B1)
A3 = Power(C3, B1)
....
An = Power(Cn, B1)

How can I increment column C while keeping B constant at B1 by using right-bottom mouse pointer dragging on column A? Or is there another way?

[dongwi]

Just found out about absolute using $ to prevent autofill from happening
B$1 will do

Learn from here: http://answers.yahoo.com/question/in...9193842AAmuqc2

[JBeaucaire]

Good job.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].