Lock or unlock specific areas of a protected worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2798417%22%20slang%3D%22en-US%22%3ELock%20or%20unlock%20specific%20areas%20of%20a%20protected%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2798417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EHi%20Alll%2C%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EI%20want%20to%20give%20selected%20user%20access%20to%20only%20edit%20a%20range%20and%20other%20to%20edit%20another%20for%20Excel%20online%20(web).%20I%20have%20followed%20there%20instruction%20but%20I%20am%20still%20unsuccessful.%20Please%20can%20you%20advise%20on%20what%20I%20could%20do.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%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(microsoft.com)%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2798417%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2798456%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20or%20unlock%20specific%20areas%20of%20a%20protected%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2798456%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1171043%22%20target%3D%22_blank%22%3E%40sslamang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20find%20more%20infos%20in%20the%20Link%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fshare-and-collaborate-with-excel-for-the-web-c8ab30a3-c0fa-473e-b508-0f5186bd47a2%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EShare%20and%20collaborate%20with%20Excel%20for%20the%20web%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EShare%20your%20workbook%20with%20others%2C%20so%20you%20can%20work%20together%20on%20the%20file%20at%20the%20same%20time.%20For%20more%20info%2C%20see%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcollaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECollaborate%20on%20Excel%20workbooks%20at%20the%20same%20time%20with%20co-authoring%3C%2FA%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20with%20these%20information%20%2F%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Alll, 

 

I want to give selected user access to only edit a range and other to edit another for Excel online (web). I have followed there instruction but I am still unsuccessful. Please can you advise on what I could do. 

 

Lock or unlock specific areas of a protected worksheet (microsoft.com)

3 Replies

@sslamang 

You will find more infos in the Link

Share and collaborate with Excel for the web

Share your workbook with others, so you can work together on the file at the same time. For more info, see Collaborate on Excel workbooks at the same time with co-authoring.

 

Hope I could help you with these information / links.

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE  I am looking for a specific range for the user to edit not the entire workbook. I have tried this methods but it does not work. The user and edit the whole workbook and not just a range. 

@sslamang 

Sorry for the late reply, but I am very limited in time at the moment.

Here ien a quick link with the associated information.

How to allow certain users to edit cells range in Excel?

In general, a protected workbook cannot be edited by others unless they have the password. But sometimes, you may allow certain users to edit a cells range of the protected workbook. Now, following this tutorial, you can get this operation done in Excel.

 

Hope I was able to help you

 

Nikolino

I know I don't know anything (Socrates)