Go to the Formulas ribbon, in Formula Auditing section select Show Formulas so you can see the progression of all the formulas.
In column B all those D3 should be $D$3 and in column K the K3 should be $K$3 for the formulas to maintain the addition of the constant when being dragged.
|