Formulas can be copied from one cell to other cells in Excel. To copy formulas in Excel:
Another way to copy formulas is by using Autofill, or dragging the Fill Handle in the cell containing the formula to the other cell or cells in which you wish to copy the formula. Autofill, which was introduced earlier in this course, is especially useful for copying formulas.
To use Autofill to copy formulas:
When working with formulas, if you wish to display the formula within its associated cell in a worksheet, in Excel 2013, select the FORMULA tab and in the Formula Auditing group, select Show Formulas.
You can toggle this option on and off by selecting and de-selecting this option.