Copying+Formulas+with+Relative+Cell+References+or+with+Absolute+Cell+References

Copying Formulas with Relative Cell references Use copy and paste commands or the fill handle to copy formulas.Copying a formula to a new cell.Excell substitutes new cell references so that the relationship of the cells to the formula remains not changed. Auto fill feature can be used for filling cells with sequential text or valuesMonths of the year; days of the week; or text plus a number (Quarter 1, Quarter 2, etc.) Drag the fill handle to extend an existing sequence.
 * You could Reuse formulas you have created

Copying Formulas with absolute Cell References
 * Apply absolute cell references before copying a formula if you want one or more cell references to remain unchanged in relation to the formula