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. Marching "ants" appear around the copied cell(s).

 

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