Please turn off the caps lock, it looks like you are SHOUTING.

If you want to multiply a column of cells by a single cell, simply
change the formula to an absolute reference.

i.e. A1*$H$7

When you fill this down/across, it will change to B1*$H$7, C1*$H$7,
etc.


HTH,
JP

On Feb 15, 1:56*pm, FROGGYDOLLY
wrote:
I HAVE A COLUMN OF 200 CELLS THAT I WANT TO MULTIPLY BY A CONSTANT CELL.

HOW DO I LOCK THE CONSTANT CELL IN THE FORMULA SO WHEN I COPY IT DOWN THE
COLUMN THAT CELL STAYS THE SAME ?

EXAMPLE: THE CONSTANT CELL IS H7, WHEN I COPY THE FORMULA FROM THE FIRST
CELL (A1*H7), I WANT THE 200 CELLS TO FOLLOW HAVING THE SAME CONSTANT CELL *-
B1*H7, C1*H7, D1*H7, E1*H7, ......