HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?

FROGGYDOLLY

unread,

Feb 15, 2008, 1:56:03 PM2/15/08

to

I HAVE A COLUMN OF 200 CELLS THAT I WANT TO MULTIPLY BY A CONSTANT CELL.

HOW DO I LOCK THE CONSTANT CELL IN THE FORMULA SO WHEN I COPY IT DOWN THE
COLUMN THAT CELL STAYS THE SAME ?

EXAMPLE: THE CONSTANT CELL IS H7, WHEN I COPY THE FORMULA FROM THE FIRST
CELL (A1*H7), I WANT THE 200 CELLS TO FOLLOW HAVING THE SAME CONSTANT CELL -
B1*H7, C1*H7, D1*H7, E1*H7, ......

JP

unread,

Feb 15, 2008, 2:07:07 PM2/15/08

to

Please turn off the caps lock, it looks like you are SHOUTING.

If you want to multiply a column of cells by a single cell, simply
change the formula to an absolute reference.

i.e. A1*$H$7

When you fill this down/across, it will change to B1*$H$7, C1*$H$7,
etc.

HTH,
JP

On Feb 15, 1:56 pm, FROGGYDOLLY

T. Valko

unread,

Feb 15, 2008, 2:05:52 PM2/15/08

to

Try it like this:

=A1*H$7

The $ "locks" the row number.

Likewise, if you were copying across a row =A1*$H7, "locks" the column
letter.

$H$7 "locks" both column and row.

--
Biff
Microsoft Excel MVP

"FROGGYDOLLY" <FROGG...@discussions.microsoft.com> wrote in message
news:1058CD88-3F25-4D18...@microsoft.com...

>I HAVE A COLUMN OF 200 CELLS THAT I WANT TO MULTIPLY BY A CONSTANT CELL.
>
> HOW DO I LOCK THE CONSTANT CELL IN THE FORMULA SO WHEN I COPY IT DOWN THE
> COLUMN THAT CELL STAYS THE SAME ?
>
> EXAMPLE: THE CONSTANT CELL IS H7, WHEN I COPY THE FORMULA FROM THE FIRST
> CELL (A1*H7), I WANT THE 200 CELLS TO FOLLOW HAVING THE SAME CONSTANT

FSt1

unread,

Feb 15, 2008, 2:07:01 PM2/15/08

to

hi
use absolute references ie
not H7
use $H$7
or
=(A1*$H$7)

regards
FSt1

Kevin B

unread,

Feb 15, 2008, 2:06:01 PM2/15/08

to

When you enter the formula you can make the reference to H7 abslolute by

Either typing $H$7 or by typing H7 and pressing the F4 key.

Then, when you copy the formula the cell reference doesn't change.

The $ before the column letter says don't adjust the column reference and
the $ row number says don't adjust the row reference.

Look up Absolute References in Help for a more detailed explanation.
--
Kevin Backmann

Gord Dibben

unread,

Feb 15, 2008, 2:40:02 PM2/15/08

to

You say you have a column of 200 cells but then you describe multiplying cells
across row 1(A1, B1, C1 etc.) by a constant in H7

Which is it? A column or a row.?

Whatever the case........If a one-time operation enter the constant number in an
unused cell.

Select and copy.

Select the range to of cells to multiply and edit>paste special>multiply>ok>esc.

Gord Dibben MS Excel MVP

FROGGYDOLLY

unread,

Feb 15, 2008, 3:19:01 PM2/15/08

to

KEVIN,

THANKS SO MUCH. I WAS DRAWING AN "ABSOLUTE" BLANK ON HOW DO IT. NOW THAT
I'VE READ YOUR RESPONSE - I REMEMBER.

THANKS,

MICHELLE

FROGGYDOLLY

unread,

Feb 15, 2008, 3:21:02 PM2/15/08

to

THANKS !

FROGGYDOLLY

unread,

Feb 15, 2008, 3:24:00 PM2/15/08

to

THANKS SO MUCH.

MICHELLE

T. Valko

unread,

Feb 15, 2008, 4:16:13 PM2/15/08

to

You're welcome!

--
Biff
Microsoft Excel MVP

"FROGGYDOLLY" <FROGG...@discussions.microsoft.com> wrote in message

news:5CBF0FFE-BA23-40EC...@microsoft.com...

tc

unread,

Apr 22, 2010, 10:18:46 AM4/22/10

to

thanks for the tip

T. Valko wrote:

Re: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
15-Feb-08

Try it like this:

=A1*H$7

The $ "locks" the row number.

Likewise, if you were copying across a row =A1*$H7, "locks" the column
letter.

$H$7 "locks" both column and row.

--
Biff
Microsoft Excel MVP

"FROGGYDOLLY" <FROGG...@discussions.microsoft.com> wrote in message
news:1058CD88-3F25-4D18...@microsoft.com...

Previous Posts In This Thread:

On Friday, February 15, 2008 1:56 PM
FROGGYDOLL wrote:

HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?

I HAVE A COLUMN OF 200 CELLS THAT I WANT TO MULTIPLY BY A CONSTANT CELL.

HOW DO I LOCK THE CONSTANT CELL IN THE FORMULA SO WHEN I COPY IT DOWN THE
COLUMN THAT CELL STAYS THE SAME ?

EXAMPLE: THE CONSTANT CELL IS H7, WHEN I COPY THE FORMULA FROM THE FIRST

CELL (A1*H7), I WANT THE 200 CELLS TO FOLLOW HAVING THE SAME CONSTANT CELL -

B1*H7, C1*H7, D1*H7, E1*H7, ......

On Friday, February 15, 2008 2:05 PM
T. Valko wrote:

Re: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
Try it like this:

=A1*H$7

The $ "locks" the row number.

Likewise, if you were copying across a row =A1*$H7, "locks" the column
letter.

$H$7 "locks" both column and row.

--
Biff
Microsoft Excel MVP

"FROGGYDOLLY" <FROGG...@discussions.microsoft.com> wrote in message
news:1058CD88-3F25-4D18...@microsoft.com...

On Friday, February 15, 2008 2:06 PM
kbackman wrote:

When you enter the formula you can make the reference to H7 abslolute byEither
When you enter the formula you can make the reference to H7 abslolute by

Either typing $H$7 or by typing H7 and pressing the F4 key.

Then, when you copy the formula the cell reference doesn't change.

The $ before the column letter says don't adjust the column reference and
the $ row number says don't adjust the row reference.

Look up Absolute References in Help for a more detailed explanation.
--
Kevin Backmann

"FROGGYDOLLY" wrote:

On Friday, February 15, 2008 2:07 PM
FSt wrote:

hiuse absolute references ienot H7use $H$7or

hi
use absolute references ie
not H7
use $H$7
or
=(A1*$H$7)

regards
FSt1

"FROGGYDOLLY" wrote:

On Friday, February 15, 2008 2:08 PM
Roni wrote:

Use the dollar sign to freeze the column ($H7), the row (H$7), or both
Use the dollar sign to freeze the column ($H7), the row (H$7), or both ($H$7)

"FROGGYDOLLY" wrote:

On Friday, February 15, 2008 2:08 PM
demechani wrote:

=A1*$H$7The dollar sign will "fix" it, ie make the cell ref absoluteBtw, pl
=A1*$H$7
The dollar sign will "fix" it, ie make the cell ref absolute

Btw, pl don't use all caps. Hard on the eyes, and considered impolite by many.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

On Friday, February 15, 2008 2:40 PM
Gord Dibben wrote:

You say you have a column of 200 cells but then you describe multiplying
You say you have a column of 200 cells but then you describe multiplying cells
across row 1(A1, B1, C1 etc.) by a constant in H7

Which is it? A column or a row.?

Whatever the case........If a one-time operation enter the constant number in an
unused cell.

Select and copy.

Select the range to of cells to multiply and edit>paste special>multiply>ok>esc.

Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 10:56:03 -0800, FROGGYDOLLY
<FROGG...@discussions.microsoft.com> wrote:

On Friday, February 15, 2008 3:19 PM
FROGGYDOLL wrote:

KEVIN,THANKS SO MUCH. I WAS DRAWING AN "ABSOLUTE" BLANK ON HOW DO IT.
KEVIN,

THANKS SO MUCH. I WAS DRAWING AN "ABSOLUTE" BLANK ON HOW DO IT. NOW THAT
I'VE READ YOUR RESPONSE - I REMEMBER.

THANKS,

MICHELLE

"Kevin B" wrote:

On Friday, February 15, 2008 3:21 PM
FROGGYDOLL wrote:

RE: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
THANKS !

"FSt1" wrote:

On Friday, February 15, 2008 3:24 PM
FROGGYDOLL wrote:

Re: HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
THANKS SO MUCH.

MICHELLE

"T. Valko" wrote:

On Friday, February 15, 2008 4:16 PM
T. Valko wrote:

You're welcome!
You're welcome!

--
Biff
Microsoft Excel MVP

On Saturday, February 16, 2008 9:10 PM
JP wrote:

Please turn off the caps lock, it looks like you are SHOUTING.
Please turn off the caps lock, it looks like you are SHOUTING.

If you want to multiply a column of cells by a single cell, simply
change the formula to an absolute reference.

i.e. A1*$H$7

When you fill this down/across, it will change to B1*$H$7, C1*$H$7,
etc.

HTH,
JP

On Feb 15, 1:56=A0pm, FROGGYDOLLY
<FROGGYDO...@discussions.microsoft.com> wrote:
=A0-

On Tuesday, May 12, 2009 9:50 AM
Nic Gur wrote:

Multiplication by constant cell
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

Submitted via EggHeadCafe - Software Developer Portal of Choice
C# And The Little Iterator That Could
http://www.eggheadcafe.com/tutorials/aspnet/f0cfca12-7398-4b84-a232-0ae26adaa533/c-and-the-little-iterato.aspx