Creating Complex Formulas
Sometimes you'll write a formula that gets used various places within a worksheet. For example, a spreadsheet may contain several columns of numbers. Each column will contain a formula that adds all of the numbers in it. You could write the formula several times, once in each column, or you could copy and paste it into each column. The fill formula method allows you to copy a formula and fill it into many different cells at the same time.
The mouse pointer changes to a black crosshair when passed over the fill handle, or the square box in the lower-right corner of the cell.
The cell references in a formula are automatically updated when the formula is copied to other cells in the spreadsheet.
You can also copy and paste formulas to other cells. This is discussed on the next page.