Repeating formulas in excel

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
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.




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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