How to Copy Formulas Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Select the cell with the formula (e.g., G3), then hover over its bottom-right corner until the cursor becomes a plus sign.
2. Click, hold, and drag the cursor down through the rows where you want to copy the formula, then release the mouse button.
3. Alternatively, you can double-click the left mouse button.
4. Excel will automatically fill the formula down the column to match the adjacent data in the neighboring column.