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
Related:
 Repeating formulas in excel
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Screenshot in excel  Guide
 Little alchemy formulas  Guide
 Formula bar in excel missing  Guide
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