Guide

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.