Protected cells in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-216566%22%20slang%3D%22en-US%22%3EProtected%20cells%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216566%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20set%20up%20an%20excel%20document%20so%20that%20one%20range%20of%20cells%20can%20be%20edited%20with%20a%20password%20and%20the%20rest%20of%20the%20document%20does%20not%20need%20a%20password%3F%3C%2FP%3E%3CP%3ETks%3C%2FP%3E%3CP%3Ecli%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-216566%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1460624%22%20slang%3D%22en-US%22%3ERe%3A%20Protected%20cells%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F165636%22%20target%3D%22_blank%22%3E%40Cliona%20McCabe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ejust%20use%20protect%20sheet%20in%20the%20review%20tab%20but%20before%20that%2C%20you%20have%20unticked%20all%20the%20cells%20you%20need%20to%20be%20free%2C%20then%20rest%20will%20get%20locked%20and%20no%20one%20can't%20change%20except%20for%20those%20have%20the%20password.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHemn%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516462%22%20slang%3D%22de-DE%22%3ESubject%3A%20Protected%20cells%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516462%22%20slang%3D%22de-DE%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fsperren-oder-entsperren-von-bestimmten-bereichen-eines-gesch%25C3%25BCtzten-arbeitsblatts-75481b72-db8a-4267-8c43-042a5f2cd93a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fsperren-oder-entsperren-von-bestimmten-bereichen-eines-gesch%25C3%25BCtzten-arbeitsblatts-75481b72-db8a-4267-8c43-042a5f2cd93a%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fsperren-oder-entsperren-von-bestimmten-bereichen-eines-gesch%25C3%25BCtzten-arbeitsblatts-75481b72-db8a-4267-8c43-042a5f2cd93a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fsperren-oder-entsperren-von-bestimmten-bereichen-eines-gesch%25C3%25BCtzten-arbeitsblatts-75481b72-db8a-4267-8c43-042a5f2cd93a%3C%2FA%3E%20%3CBR%20%2F%3E%20Maybe%20that%20will%20help%20you%20quickly.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello

is it possible to set up an excel document so that one range of cells can be edited with a password and the rest of the document does not need a password?

Tks

cli

2 Replies

@Cliona McCabe 

just use protect sheet in the review tab but before that, you have unticked all the cells you need to be free, then rest will get locked and no one can't change except for those have the password.

 

cheers

 

Hemn