You say you have a column of 200 cells but then you describe multiplying cells
across row 1(A1, B1, C1 etc.) by a constant in H7

Which is it? A column or a row.?

Whatever the case........If a one-time operation enter the constant number in an
unused cell.

Select and copy.

Select the range to of cells to multiply and editpaste specialmultiplyokesc.


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 10:56:03 -0800, 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, ......