You're welcome!

--
Biff
Microsoft Excel MVP


"FROGGYDOLLY" wrote in message
...
THANKS SO MUCH.

MICHELLE

"T. Valko" wrote:

Try it like this:

=A1*H$7

The $ "locks" the row number.

Likewise, if you were copying across a row =A1*$H7, "locks" the column
letter.

$H$7 "locks" both column and row.

--
Biff
Microsoft Excel MVP


"FROGGYDOLLY" wrote in message
...
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
ELL -
B1*H7, C1*H7, D1*H7, E1*H7, ......