Thread: Fill handle - new column using a column and one cell

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

--
Jim
"MS" <MS@discussions.microsoft.com> wrote in message
news:A0C79967-59A2-4683-B701-EA9CB4A1A27F@microsoft.com...
|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

=A1*$C$1

--

Regards,

Peo Sjoblom

"MS" <MS@discussions.microsoft.com> wrote in message
news:A0C79967-59A2-4683-B701-EA9CB4A1A27F@microsoft.com...
> 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

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

"MS" wrote:

> 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

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

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

--
Jim
"MS" <MS@discussions.microsoft.com> wrote in message
news:A0C79967-59A2-4683-B701-EA9CB4A1A27F@microsoft.com...
|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

=A1*$C$1

--

Regards,

Peo Sjoblom

"MS" <MS@discussions.microsoft.com> wrote in message
news:A0C79967-59A2-4683-B701-EA9CB4A1A27F@microsoft.com...
> 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

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

"MS" wrote:

> 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

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.

MS wrote:
>
> 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

--

Dave Peterson