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

[IldaR365]

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]

@IldaR365 

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.

[#3]

@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)