Copying Formulas and Functions

Contact Us or call 1-877-932-8228
Copying Formulas and Functions

Copying Formulas and Functions

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

  1. Select the cell which contains the formula you wish to copy.
  2. On the HOME tab, in the Clipboard group, click the Copy command.Copy in Clipboard Group of Home Tab
  3. Select the cell into which you wish to copy the formula.
  4. On the HOME tab, in the Clipboard group, click the Paste command.Paste in Clipboard Group of Home Tab

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:

  1. Enter a formula in one cell:Autofill Formula
  2. Click on the Fill Handle, which is located in the bottom right cell of the selected cells:Fill Handle
  3. Drag the Fill Handle for as many rows or columns as desired:Drag Fill Handle
  4. Release the mouse to enter the formula into the desired cells:Autofill Formula

Displaying 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.

Show Formulas in Auditing Group of Formula Tab

You can toggle this option on and off by selecting and de-selecting this option.

Next