I have a series of variable values in one column. I also have a fixed value
in one cell. I want to multiply all of the variable values by the fixed
value. How do I copy the formula for one calculation down the entire adjacent
column without Excel changing the cell number that contains the fixed value.

Look in help at the difference between absolute and relative addressing.
--
David Biddulph

Bill R wrote:
I have a series of variable values in one column. I also have a fixed
value in one cell. I want to multiply all of the variable values by
the fixed value. How do I copy the formula for one calculation down
the entire adjacent column without Excel changing the cell number
that contains the fixed value.

If you have values in A1 to A10 and want to multiply all those values by B1
then put the following formula in C1 and copy down:

=A1*$B$1


"Bill R" wrote in message
...
I have a series of variable values in one column. I also have a fixed value
in one cell. I want to multiply all of the variable values by the fixed
value. How do I copy the formula for one calculation down the entire
adjacent
column without Excel changing the cell number that contains the fixed
value.

Without any formulas........................

Select the cell with the fixed rate.

Copy that cell.

Select the range to change and Paste SpecialMultiplyOKEsc

But you may want to have the formulas so's you can change the fixed rate for
what-if.

See other posts for cell referencing.


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 15:08:26 -0700, Bill R
wrote:

I have a series of variable values in one column. I also have a fixed value
in one cell. I want to multiply all of the variable values by the fixed
value. How do I copy the formula for one calculation down the entire adjacent
column without Excel changing the cell number that contains the fixed value.