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.