View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FROGGYDOLLY FROGGYDOLLY is offline
external usenet poster
 
Posts: 4
Default HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?

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, ......