Excel Help

[streetkid]

I hope this is the right place for this.

I'm having trouble trying to do something and I can't think of a way to search for the answer without explaining it entirly, and I'm sure the solution is really simple to you guys :p. Anyways, heres what I'm trying to do.

in cell A1 there is a number, then in cells B1-B10 there are other numbers. Now in column C I want it to have B1*A1 for C1, B2*A1 for C2, B3*A1 for C3 and so on. In each calculation I want it to mutiply by A1 every time, but when i try and drag the calculation down C1-C10 it incriments the A column too, A2 A3 A4, but I want it to stick to A1 the whole time. How would I do that?

Thanks


edit, I just now saw the General Software subforum, I'm such a dork :eek: if a mod could move it that'd be great :X

[beanman101283]

In cell C1 make your formula "=B1*$A$1" Then fill the formula down. The dollar signs make it an absolute reference so it won't change when you drag it down.

[streetkid]

you're the best, thank you