Wish I had found you before I spent $100 to take a class. Thanks!”

Online Learner

Creating Opportunities For A Better Life.®

Excel XP

Single page view print copy

Creating Complex Formulas

Copy and Paste Formulas

The process to copy and paste a formula is identical to that process used to copy and paste text.

To Copy and Paste a Formula:

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

    Copy a Formula

  • Select the cell where the copied formula is to be pasted.
  • Press the Enter key. The formula is copied to the new location.
1 2 3 4 5 6 7 8 9