View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
analyst storm
 
Posts: n/a
Default How do I keep a formula constant in dragging cells below the rows

I want to fill a column of cells with the same fomula in each cell but when a
drag the cells the formula keeps changing by adding 1 to each cell reference.
I want the same formula in each cell over namy rolls in a column.