Previous Topic Next Topic

Repeating formulas in excel

Closed
Duke243 - Mar 8, 2011 at 04:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 8, 2011 at 05:13 PM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response