Mar 8, 2011 at 04:57 PM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Mar 8, 2011 at 05:13 PM
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.
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022766 Mar 8, 2011 at 05:13 PM
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