# How to copy formula with one cell constant

Mark
Guest
Posts: n/a

 29th Jan 2008
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

Pete_UK
Guest
Posts: n/a

 29th Jan 2008
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 <(E-Mail Removed)> 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

Stan Brown
Guest
Posts: n/a

 31st Jan 2008
Tue, 29 Jan 2008 11:10:05 -0800 from Mark
<(E-Mail Removed)>:
> 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
"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/

holidaymantra@gmail.com
Guest
Posts: n/a

 7th Jul 2012

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 <(E-Mail Removed)> 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

New Member
Join Date: Jul 2012
Posts: 2

 14th Jul 2012
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

Quote:
 Originally Posted by 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 Thanks

Guest
Posts: n/a

 10th Aug 2012
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

ianspringham@gmail.com
Guest
Posts: n/a

 20th Mar 2014
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!

wabbleknee
Guest
Posts: n/a

 22nd Mar 2014
Try \$B\$2

wrote in message
news:(E-Mail Removed)...

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!

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?b2xkIGdyZXkgd2hpc2tlcnM=?= Microsoft Excel Misc 3 19th Aug 2006 06:24 AM =?Utf-8?B?ZXhjZWwgcm9va2ll?= Microsoft Excel Misc 3 26th Apr 2006 07:25 PM =?Utf-8?B?anVudGlwb2lra2E=?= Microsoft Excel Misc 2 15th Dec 2005 02:36 AM =?Utf-8?B?VGlhbmE=?= Microsoft Excel Worksheet Functions 3 26th Jul 2005 07:27 PM =?Utf-8?B?SlFMb2dhbg==?= Microsoft Excel Misc 1 29th Mar 2005 08:07 PM

Features