Copying a formula to column using a value from a particular cell

E

effnbee

I wish to copy a formula to a number of rows in a column using a value from a
particular cell in each formula. What is happening is that when I paste the
copied formula the reference to the cell with the value I wish to use is
moved down with the other cell references.
 
M

Mike

If you use absolute references then it should do what you want. For example

=$A$2*6

will always reference cell A2 no matter where it is copied to.

Mike
 
Top