I’m not very familiar with Excel and am trying to do some simple programming with it.
Suppose I’ve got a formula in a cell: =E7/(E7*(-E8)-((E6E9K12K12/2E10)))
and I want to copy it repeatedly to the cell below;
But I only want to increment the references to cells in column K, like this: =E7/(E7*(-E8)-((E6E9K13*K13/2*E10))). I don’t want E7 to become E8 (ditto for the remaining E’s)
Is there some prefix or indication that indicates to Excel I don’t want the other cell references incremented when I copy this formula to the 99 following cells? (using CTRL-D)
Thanks for any and all help. Hope this makes sense.
Tip: use the F4 key to cycle around the possible combinations of relative/absolute… put your cursor on the cell reference in the formula bar, and repeatedly press F4 - you’ll see what I mean.