# How to copy formula with one cell constant

Discussion in 'Microsoft Excel Worksheet Functions' started by Mark, Jan 29, 2008.

1. ### MarkGuest

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

Mark, Jan 29, 2008

2. ### Pete_UKGuest

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

Pete_UK, Jan 29, 2008

3. ### Stan BrownGuest

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
"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/

Stan Brown, Jan 31, 2008
4. ### Guest

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

, Jul 7, 2012
5. ### Mark Flanagan

Joined:
Jul 14, 2012
0
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

Mark Flanagan, Jul 14, 2012
6. ### Guest

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

, Aug 10, 2012
7. ### Guest

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!

, Mar 20, 2014
8. ### wabblekneeGuest

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!

wabbleknee, Mar 22, 2014