View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
old grey whiskers old grey whiskers is offline
external usenet poster
 
Posts: 2
Default autofill with one part of the formula refering to a constant cell

how do I use autofill if part of the formula refers to one cell and all other
other calculations down the row refer to that same cell? eg
Cell D1 is =C1/C10*100
Cell D2 is =C2/C10*100
Cell D3 is =C3/C10*100
--
old grey whiskers