Forum Discussion
How can I protect only a selection of rows in a table from other users' modifications?
For example, I have a table with 7 columns on excel and I want to share it with another user who should only be able to modify column 7 and NOT the rest of the columns. I do not know how I should set this up.
Thanks in advance for your help,
Ilda365
2 Replies
Lock or unlock specific areas of a protected worksheet
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
first select the whole sheet, right click and then click the format cells option:
In the protection tab, unclick locked:
Then select the columns you would like to hide and make sure to click locked in the protection tab (by clicking format cells again):
Now, go to protect sheet and stablish a password:
After that you should be able to edit just unlocked columns. The rest is going to be locked for other users unless they now the password.
I hope this answers your question.
