[Solved] Batch edit of formulas in a column

[jpm2]

I wondered if there's an option to batch edit formulas that are in same column but different rows?

Due to my misunderstanding of priorities I have to add ( ) to existing formulas. Every formula is different though, because they are in different rows.
what I've got etc
=F87+H87+J87+M87+N87*1.05+O87
=F88+H88+J88+M88+N88*1.05+O87
=F89+H89+J89+M89+N89*1.05+O87

what I'd like to achieve
=(F87+H87+J87+M87+N87)*1.05+O87
=(F88+H88+J88+M88+N88)*1.05+O87
=(F89+H89+J89+M89+N89)*1.05+O87

Thanks so much.
JP

Microsoft W10
Open Office Calc 4.1

[robleyd]

No need for batch editing. Simply edit the first formula to your needs, then use the drag handle at the bottom right of the cell to drag it down as far as needed.

aoo_drag.png (17.57 KiB) Viewed 930 times

Specifically your existing formula

Code: Select all

=F87+H87+J87+M87+N87*1.05+O87 

will need to be changed to

Code: Select all

=(F87+H87+J87+M87+N87)*1.05+$O$87 

See [Tutorial] Absolute, relative and mixed references if you don't know why I've used dollar signs in the addresses.

[jpm2]

Thank you so much robleyd
Saved me a ton of time. Just shows what a self-learned newbie I am. Thank you!!

Further to this:
How can I do this without affecting individual cell formatting ie borders, colours etc

[MrProgrammer]

How can I do this without affecting individual cell formatting ie borders, colours etc

Edit the first formula. Edit → Copy. Select the target cells (the others in that column). Edit → Paste Special → Formulas → OK.

[jpm2]

Thanks so much!!
All sorted