Read-only with editable cells
Solved
Estblnt
-
Anonymous user -
Anonymous user -
Hello everyone,
I'm facing a problem.
I've created a Google Sheet that is intended to be "community-oriented," meaning that everyone with the link has access to the file but in read-only mode.
However, I need certain cells to remain editable so that data can be entered (manually or via a dropdown list allowing for new calculations).
I don't know how to do this, do you have any suggestions? Solutions?
Looking forward to hearing from you
Have a great day
Estéban
I'm facing a problem.
I've created a Google Sheet that is intended to be "community-oriented," meaning that everyone with the link has access to the file but in read-only mode.
However, I need certain cells to remain editable so that data can be entered (manually or via a dropdown list allowing for new calculations).
I don't know how to do this, do you have any suggestions? Solutions?
Looking forward to hearing from you
Have a great day
Estéban
4 réponses
Hello,
You can share your document in writing while first locking the cells/sheets that you do not want to be modified:
https://support.google.com/docs/answer/1218656?co=GENIE.Platform%3DDesktop&hl=fr
Feel free to make a copy of your file before sharing it (in case you haven't locked your file correctly).
You can share your document in writing while first locking the cells/sheets that you do not want to be modified:
https://support.google.com/docs/answer/1218656?co=GENIE.Platform%3DDesktop&hl=fr
Feel free to make a copy of your file before sharing it (in case you haven't locked your file correctly).