Help with MS EXCEL with multiplying a column by a single constant?

Question

Hello there,

Here is a description:

I have a list of numbers in A1-A60. I want to Display those numbers Multiplied by a Constant in C1 in rows B1-B60.
The first row of B1 will be (=A1*C1)

Now I want to drag and do the same for all colums.
Here is where the problem is. The auto formula does this:
C2 = (A2*C2), C3 = (A3*C3)

I want the As to go A2,A3,A4 but the C1 to remain C1 and not go C2,C3 etc..

If I remember right, I have to add asymbol before the original C1.. like a $ or & or something like that.

Please refresh my memory!
Thanks!

Thanks brian.. you're right on the money :)

I forgot it was $C$2 and not $C2.

Thank you all for your answers!

Answer 1

You want what is called an 'absolute reference' to cell C1
A quick way to make an Absolute reference is
insert the = sign in the cell where you want the first result (B1), click on the first number (A1) and then insert the * sign.
Click on the cell you want the absolute reference to (C1) and then click on the function key F4 to make it absolute!
By using the F4 key you don't have to remember where to insert the $ signs, it does it for you!

Answer 2

Create a name. INSERT | NAME | CREATE. Give it a name. Any old name. Doesn't much matter what name. So, let's say, "Cons" is the name. Then you write your formula like this:

C1=(A1*Cons). Now drag it down to the other cells.

You should see C2=(A2*Cons), C3=(A3*Cons)

Answer 3

a million. enter the consistent in some empty cellular in yet another column. 2. reproduction the consistent. 3. spotlight column A. 4. go with Paste particular from the edit menu or the contextual menu at the same time as correct clicking the column. 5. go with multiply. 6. click ok.

Answer 4

Brian is correct. You can also Name a given cell so that you can use it anywhere, by using Insert->Name on a given cell.

Answer 5

Manually do the first two or three, highlight all of them, then drag.

Answer 6

B2=A2*$C$1

copy that down and you're set.