Put this formula in B2:

=A2*B$1

When you copy this down the $1 will not change.

Hope this helps.

Pete

On Jan 29, 7:10*pm, Mark wrote:
How can I copy the formula so that B2 stays constant and only the row changes?

* * * A * * *B * * C

1 * * * * * 2

2 * 10 * *=A2*B1

3 * 20 * *=A3*B1

4 *30 * * =A4*B1

Thanks