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,

Ilda365

 

2 Replies

@IldaR365 

first select the whole sheet, right click and then click the format cells option:

 

edison0019_1-1611842549175.png

 

In the protection tab, unclick locked:

 

edison0019_2-1611842594485.png

 

Then select the columns you would like to hide and make sure to click locked in the protection tab (by clicking format cells again):

 

edison0019_3-1611842661414.png

 

Now, go to protect sheet and stablish a password:

 

edison0019_4-1611842743216.png

 

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.

@IldaR365 

 

Lock or unlock specific areas of a protected worksheet

https://support.microsoft.com/en-us/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75...

 

Hope I was able to help you.

 

Nikolino

I know I don't know anything (Socrates)