software

How can I drag a formula without incrementing both of the cell values stated
in the formula?

This is the result I need:

=A4*D125
=A5*D125
=A6*D125quot;sdmccabequot; wrote:
gt; How can I drag a formula without incrementing both of the
gt; cell values stated in the formula? This is the result I need:
gt; =A4*D125
gt; =A5*D125
gt; =A6*D125

Change D125 to $D$125. One way to do that: click on the cell,
click on D125 in the formula, press F4 until you see $D$125.

You might also want $A4 (using F4 again) if you want to be able
to drag the formula across the same row and retain A4.

Great - thanks.

quot; wrote:

gt; quot;sdmccabequot; wrote:
gt; gt; How can I drag a formula without incrementing both of the
gt; gt; cell values stated in the formula? This is the result I need:
gt; gt; =A4*D125
gt; gt; =A5*D125
gt; gt; =A6*D125
gt;
gt; Change D125 to $D$125. One way to do that: click on the cell,
gt; click on D125 in the formula, press F4 until you see $D$125.
gt;
gt; You might also want $A4 (using F4 again) if you want to be able
gt; to drag the formula across the same row and retain A4.