Forum Discussion
MikeCee
Apr 17, 2022Copper Contributor
repeating the same formula on different lines
I need to add a simple formula like SUM(B3-C3) but want to add it to multiple rows at the same time.
Can I do this, or do I have to do each row at a time??
Thanks
1 Reply
Sort By
- Subodh_Tiwari_sktneerSilver Contributor
Suppose you want to place this formula in the range D3:D25 then select the range D3:D25, type your formula and hit Ctrl+Enter. This will place the formula in all the selected cells at once.