Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to protect the formatting of a cell (or a range of cells) in a Google Spreadsheet, but still allow changing the data in that (or those) cell(s).

For example, I want to add a validation rule on a cell that says the cell has to contain a number between 1 and 10, and I would like others to be able to change the value in that cell, but not the validation rule itself.

How do I do that?

So far I was only able to completely protect the cell (content + formatting) or not at all (the user can change the content as well as the formatting).

To me this seems to be an important functionality when adding access rights to spreadsheets. Is it possible that it is completely missing from Google Spreadsheets?

share|improve this question
up vote 2 down vote accepted

At this time Google Sheets doesn't have a way to protect cell format while allowing to edit its content.

How to share - Docs editors Help
Protect a range or sheet from being edited - Docs editors Help

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.