Fill handle - new column using a column and one cell

[Guest]

I have a column A1:A10 with numbers in it. I also have a cell C1 with a
number 5. I wish to create a column B1:B10 that will be as follow:
B1 = A1*C1
B2 = A2*C1
B3 = A3*C1 and so on.

I do not want to use C1, C2, C3... in my formula. Is this possible?

Thanks
MS

 

[Peo Sjoblom]

=A1*$C$1

 

[Jim Rech]

Put =A1*C$1 in B1 and fill it down.

--
Jim
|I have a column A1:A10 with numbers in it. I also have a cell C1 with a
| number 5. I wish to create a column B1:B10 that will be as follow:
| B1 = A1*C1
| B2 = A2*C1
| B3 = A3*C1 and so on.
|
| I do not want to use C1, C2, C3... in my formula. Is this possible?
|
| Thanks
| MS

 

[Guest]

Change your formula in B1 to:

=A1*$C$1

You'll then be able to copy it down without it automatically adjusting the
C1 reference.

HTH,
Elkar

 

[Dave Peterson]

Another option is to give C1 a nice name.

Select C1
Insert|Name|Define

Call it myMultiplier (or something that makes more sense for what it is)

Then you could put:

=a1*mymultiplier

and drag down.

You may find it easier to remember what the formula is supposed to do if you
give that cell a nice memorable name.