Ask Your Question

Protect All Formulas

asked 2019-01-29 12:34:10 +0200

Mxbutterfield gravatar image

Hi everyone,

I want to protect all cells containing a formula. In excel I used the following:

  1. Highlight all cells
  2. Format, unprotect
  3. Go To function, select formulas (highlights all cells containing formulas, not data or empty)
  4. Format, protect
  5. Protect sheet

Is there an easy way to do this in calc?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-01-29 14:07:51 +0200

JohnSUN gravatar image

Yes, this easy way present


edit flag offensive delete link more

answered 2019-01-29 13:50:37 +0200

Lupp gravatar image

updated 2019-01-29 14:34:28 +0200

Easy? Depends.

If there are no cells preset to accept strings only (under Format Cells...>Numbers>Format code>@) and containing something starting with the character = (correction thanks to JohnSun: or the pair of characters {= } , you find cells containing a formula with the help of >Edit>Find & Replace.

Enable Regular expressions.
Enter ^= behind Find: Correction: Edit ^\{?= behind Find:
Select Formulae behind Search in:
Click Find All
All the cells containing formulae are now selected, but the mode of selection is non-standard. Therefore you need to:
Ctrl+Click on one of the found cells twice.
Rightclick on that cell now to open the context menu.
Select the menu item Format Cells... and make the settings you want.

See this example. So easy!

If there are texts ... containing = as the first character ... : Edit your question and append this specific requirement.

edit flag offensive delete link more


Perhaps string for Find must be ^[=|\{]?

JohnSUN gravatar imageJohnSUN ( 2019-01-29 14:12:44 +0200 )edit

Thanks for reminding me of array-formulae.
I will edit my answer and replace the excample.

Lupp gravatar imageLupp ( 2019-01-29 14:28:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-29 12:34:10 +0200

Seen: 408 times

Last updated: Jan 29 '19