I P Fill Right N


We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right.
ABC
1=A2+$B$3=B2+$B$3=C2+$B$3
2625
37104
4987
If we were to fill right from A1 to C1 we would get the formulas displayed to the left. Notice that the second part of the equation is FIXED or (ABSOLUTE REFERENCE so always references B3 which is 10).

Answers would be A1=16, B1=12, C1=15.


I P Fill Right N

742961

 Choose:   INTEK home   I   training  I   by Jim Tracy   I