1
To begin, open your workbook in Excel.
Drag to Copy a Formula
2
Click on the cell with the formula you want to copy.
3
Click on the small square at the bottom right of the cell and drag it to the cell where you want to copy the formula.
Right Click to Copy/Paste a Formula
4
You can also right click the cell for the formula you want to copy. Click "Copy."
5
Click in the cell where you want to apply the copied formula.
6
Right-click in the cell and click "Paste."
