It would be worth to have a look at this link to understand more on relative
and absolute references...

http://www.cpearson.com/excel/relative.aspx
--
If this post helps click Yes
---------------
Jacob Skaria


"JB Akron" wrote:

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?