Copying Formulas and Functions

Formulas can be copied from one cell to other cells in Excel. To copy formulas in Excel:

- Select the cell which contains the formula you wish to copy.
- On the
`HOME`tab, in the`Clipboard`group, click the`Copy`command. - Select the cell into which you wish to copy the formula.
- On the
`HOME`tab, in the`Clipboard`group, click the`Paste`command.

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:

- Enter a formula in one cell:
- Click on the
`Fill Handle`, which is located in the bottom right cell of the selected cells: - Drag the
`Fill Handle`for as many rows or columns as desired: - Release the mouse to enter the formula into the desired cells:

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.