Excel - specified user should be able to adjust specific column

%3CLINGO-SUB%20id%3D%22lingo-sub-2237179%22%20slang%3D%22en-US%22%3EExcel%20-%20specified%20user%20should%20be%20able%20to%20adjust%20specific%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237179%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20using%20Microsoft%20365%2C%20so%20we%20are%20logged%20in%20with%20that%20account%20when%20working%20in%20the%20document.%20Is%20there%20a%20way%20to%20give%20someone%20access%20(by%20using%20her%2Fhis%20microsoft%20365-account)%20to%20change%20a%20specific%20cell%20or%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20a%20spreadsheet%20used%20to%20order%20stuff%20for%20each%20car.%20First%20column%20is%20the%20item%2C%20the%20next%20columns%20are%20each%20time%20the%20number%20of%20each%20car.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20we're%20spread%20all%20over%20the%20country%2C%20I'll%20share%20this%20file%20with%20my%20collegues.%20But%2C%20I%20don't%20want%20anyone%20but%20me%20to%20make%20an%20order%20for%20%22my%22%20ambulance%2C%20but%20on%20the%20otherhand%20I%20don't%20want%20coworker%20X%20do%20an%20order%20for%20coworker%20Y.%20So%20I'll%20need%20to%20give%20changing-access%20for%20each%20column%20to%202%20specific%20persons.%20But%20I%20don't%20know%20how.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20if%20you%20can%20help%20me%20out!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2237179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2237203%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20specified%20user%20should%20be%20able%20to%20adjust%20specific%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1000373%22%20target%3D%22_blank%22%3E%40BartN1984%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20try%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20258px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267373iA6B6E51DC239A55A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHow%20it%20works%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ELock%20or%20unlock%20specific%20areas%20of%20a%20protected%20worksheet%20-%20Excel%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there, 

 

We are using Microsoft 365, so we are logged in with that account when working in the document. Is there a way to give someone access (by using her/his microsoft 365-account) to change a specific cell or column?

 

I've a spreadsheet used to order stuff for each car. First column is the item, the next columns are each time the number of each car. 

 

Since we're spread all over the country, I'll share this file with my collegues. But, I don't want anyone but me to make an order for "my" ambulance, but on the otherhand I don't want coworker X do an order for coworker Y. So I'll need to give changing-access for each column to 2 specific persons. But I don't know how. 

 

Thanks if you can help me out!

4 Replies

@Sergei Baklan 

 

thanks for the interesting url! It has put me on the way, but I still get stuck with the permissions. 

It talks about domainnames, objecttypes etc. But I can't find where to insert emailadresses / accountnames of those who may edit.

I'm sorry, I know some basics in Excel, but I think I'm overstepping borders at this moment

 

@BartN1984 

I guess you try to do that on local machine

image.png

and you may select here only people / groups which have accounts on your local PC.

 

This functionality is more for the domain users, in this case you may select people who has accounts in your network Active Directory.  If to simplify, for corporate users who are in the same corporate network runs under Active Directory.

 

If that's not your case I don't know how to solve the task, sorry. 

Thank you for trying!
Yep, it's sort of local machine I guess.

But your assistance (getting me on the way) is greatly appreciated!