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

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

Tue, 29 Jan 2008 11:10:05 -0800 from Mark <>: > 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 ?? B2 ?? -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/

Dear pete_uk, Thanks a ton, saved lot my time and appricate your effort on this. Regards, Dr. Shashi www.holidaymantra.com On Wednesday, January 30, 2008 12:52:15 AM UTC+5:30, Pete_UK wrote: > 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

A $ sign before the column or row keeps it constant when pasted / dragged. You can scroll through the options by pressing F4 when the cell reference is highlighted. i.e. $A$2 A$2 $A2 A2 and then the cycle repeats

On Tuesday, January 29, 2008 2:10:05 PM UTC-5, 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 GOOD JOB GUYS

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!

Try $B$2 wrote in message news:... 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!