Copying Formulas with the Fill Handle
To complete the worksheet, we need to add the three formulas created above to rows 9, 10, and 11.
Since our data is laid out in rows we can copy the formulas in row 8 to rows 9 to 11.
A quick way of copying formulas is to use the fill handle.
The fill handle is the small black square in the bottom right corner of the active cell.
For this tutorial:
For help with these instructions, see the image above.
- Drag select cells D8 to F8 to highlight them.
- Place the mouse pointer over the black square in the bottom right corner of cell F8. The pointer will change to a plus sign " + ".
- Click the left mouse button and drag the fill handle down to cell F11.
- Release the mouse button. Cells D9 to E11 should contain the results of the Total Income, Deductions, and Net Salary formulas.
- Save your worksheet.
If you have followed all the steps in this tutorial your worksheet should now match the image above.
Return to Index page