Forum Discussion

MikeCee's avatar
MikeCee
Copper Contributor
Apr 17, 2022

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

  • MikeCee 

     

    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.

Resources