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
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.
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.
Related:
- Repeating formulas in excel
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Percentage formula in excel marksheet - Guide
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 8, 2011 at 05:13 PM
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
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
