EXCEL – extend range cells

If you want to extend your range down you can do this by calculating the first 2 cells with your formula and then highlighting them. You now grap the little square on the bottom right of the highlighted area and drag that down, across or both.

If you have a specific cell (e.g. D2) which you wish for to remain in all the cells you extend your range to then in your 2 initial cell calculations use the following:

Exntending Down

=G2*D$2
=G3*D$2
Extending Across

=G2*$D2
=H2*$D2
Extending Down and Across

Use $D$2 

Here’s the original source.