How do you delete formulas from more than one cell? I have tried selecting all cells and selecting "Remove Cell Contents" and the having only the formulas box checked, but it only deletes the formula out of last selected cell. Any help would be appreciated.
Thanks,
jodmcc1
[Solved] Remove formulas in multiple cells
[Solved] Remove formulas in multiple cells
Last edited by Hagar Delest on Wed Nov 06, 2013 9:49 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice 4.0.1 MacOS 10.6.8
Re: Remove formulas in multiple cells
Works for me. Did you try the backspace key too?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Remove formulas in multiple cells
I don't follow you on the backspace key. I tried selecting all cells and clicked in the formula bar and backspaced everything out and clicked the "checkmark", but again only got rid of one cell info, not all selected.
OpenOffice 4.0.1 MacOS 10.6.8
Re: Remove formulas in multiple cells
Thanks Villeroy,
Tried again and unchecked every box except "formulas" and it worked.
Tried again and unchecked every box except "formulas" and it worked.
OpenOffice 4.0.1 MacOS 10.6.8