How can I protect only a selection of rows in a table from other users' modifications?

Occasional Visitor

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,



2 Replies


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.



Lock or unlock specific areas of a protected worksheet


Hope I was able to help you.



I know I don't know anything (Socrates)