Forum Discussion
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
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.