Creating Complex Formulas

In Excel XP complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.

Copying and pasting formulas

The process to copy and paste a formula is identical to the process for copying and pasting text.

To copy and paste a formula:

  • Select the cell that contains the formula you want to copy.
  • Click the Copy button Copy button. Marching ants appear around the copied cell(s).

    Copy a Formula
  • Select the cell where the copied formula will be pasted.
  • Press the Enter key. The formula is copied to the new location.