View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JB Akron JB Akron is offline
external usenet poster
 
Posts: 11
Default dragging formulas across rows

Hello - I have a number in one cell (D2) that I need to use as a constant
value (in the denominator) to create proportions (E2/D2, F2/D2, G2/D2, etc..)
across Row 3 -E3-FS3). The drag feature will not keep D2 selected in the
denominator in subsequent cells. Instead, it creates (E2/D2, F2/E2, G2/F2,
etc..). Any possible solutions?