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