Now, use the fill handle to apply the same relative formula to cells B4 to B6. To finish this section, copy and paste the formula into cell E3, and use the fill handle again.

Click on the formula bar and close the bracket. Hit Enter. When you are done, use the Fill Handle to copy the formula to all the cells.

Duplicate a Formula After typing a formula into a cell and pressing Enter, you might be tempted to click and drag the cell's fill handle to copy it down a column. However, this can take far too ...