Excel 2007 – Copy A Formula

  1. Select the cell that contains the formula that you want to copy.
  2. On the Home tab, in the Clipboard group, click Copy.
  3. Do one of the following:
  • To paste the formula and any formatting, on the Home tab, in the Clipboard group, click Paste.
  • To paste the formula only, on the Home tab, in the Clipboard group, click Paste, click Paste Special, and then click Formulas.

 Note   You can paste only the formula results. On the Home tab, in the Clipboard group, click Paste, click Paste Special, and then click Values.

  1. Verify that the cell references in the formula produce the result that you want. If necessary, switch the type of reference by doing the following:
    1. Select the cell that contains the formula.
    2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) , select the reference that you want to change.
    3. Press F4 to switch between the combinations.