I want to extend a formula to about 20,000 rows, so holding the fill handle will take too long. Is there any I can specify a number of rows? E.g., The formula in cell C1 is =SUM(A1+B1). So, how can I get it so that the last entry is =SUM(A20000+B20000), again without manually dragging the fill handle for 20000 rows. Thanks in advance.
If the issue is only you dont want to physically drag, then one short cut would be
you do the formula for the last row
Then go to to the first row and type the formula there. Then copy the formula, press cntrl + shift and down arrow at the same time and press ctrl + d to paste the formula