Thread: 1 column multiplied by 1 row throughout sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Maeurer Rob Maeurer is offline
external usenet poster
  
Posts: 1
Default 1 column multiplied by 1 row throughout sheet
I want to copy a formula from 1 cell or a group of cells in which the column
and row values will not change.
Ex: Cell D6 = C6*D5
Cell H11 = C11*H5
Cell J15 = C15*J5
I want to be able to copy this formula into several cells without the C or
the 5 changing. How can this be achieved?

Reply With QuoteReply With Quote