How to copy formula with one cell constant
On Tuesday, 29 January 2008 20:10:05 UTC+1, 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
Very helpful - quickly solved a problem that I had never gotten round to resolving. Thanks, so much!
|