dragging formulas across rows

[JB Akron]

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?

 

[Sheeloo]

Use
=E2/$D2
and drag across

$ will keep D2 constant in the current row...
It will change to D3 in the next row below. If you don't want that then try
=E2/$D$2

 

[Jacob Skaria]

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