[Solved] Remove formulas in multiple cells

Discuss the spreadsheet application
Post Reply
jodmcc1
Posts: 7
Joined: Mon Dec 27, 2010 6:08 am

[Solved] Remove formulas in multiple cells

Post by jodmcc1 »

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
Last edited by Hagar Delest on Wed Nov 06, 2013 9:49 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.0.1 MacOS 10.6.8
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Remove formulas in multiple cells

Post by Villeroy »

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
jodmcc1
Posts: 7
Joined: Mon Dec 27, 2010 6:08 am

Re: Remove formulas in multiple cells

Post by jodmcc1 »

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
jodmcc1
Posts: 7
Joined: Mon Dec 27, 2010 6:08 am

Re: Remove formulas in multiple cells

Post by jodmcc1 »

Thanks Villeroy,
Tried again and unchecked every box except "formulas" and it worked.
OpenOffice 4.0.1 MacOS 10.6.8
Post Reply