Reduced Row Echelon Form in Excel
16. To carry out the row operation
-4R1+R2 > R2, click in cell A10 and type
= -$A$6*A5+A6 and Enter. You should
see the row operation applied to the first
entry of the second row resulting in a 0.
The $ in this formula is an absolute
reference that ensures that the opposite
of the entry in A6 is always used to do
the row operation.
17. Click the cursor in cell A10. Use your
mouse to click on the handle in the lower
right hand corner of the black box around
the cell. While holding the left mouse
button, drag the cursor to cell D10 and
release the mouse button. This will fill the
cells with the row operation.