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

%3CLINGO-SUB%20id%3D%22lingo-sub-2106152%22%20slang%3D%22en-US%22%3EHow%20can%20I%20protect%20only%20a%20selection%20of%20rows%20in%20a%20table%20from%20other%20users'%20modifications%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106152%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20example%2C%20I%20have%20a%20table%20with%207%20columns%20on%20excel%20and%20I%20want%20to%20share%20it%20with%20another%20user%20who%20should%20only%20be%20able%20to%20modify%20column%207%20and%20NOT%20the%20rest%20of%20the%20columns.%20I%20do%20not%20know%20how%20I%20should%20set%20this%20up.%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help%2C%3C%2FP%3E%3CP%3EIlda365%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106152%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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)