Thread: Dragging cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tommy Tommy is offline
external usenet poster
 
Posts: 70
Default Dragging cells

I'm trying to use a formula to calculate values into a column and they
require the values directly to the left of them to be divided by a single
cell. So the numerator will be a new number each row down, but the
denominator needs to be the same cell. I was wondering how to tell all the
cells in the column to use that same reference cell instead of having each
successive row use the next row down under the reference.