Need to Lock only certain cells (Excel)

%3CLINGO-SUB%20id%3D%22lingo-sub-2619825%22%20slang%3D%22en-US%22%3ENeed%20to%20Lock%20only%20certain%20cells%20(Excel)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2619825%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20lock%20certain%20cells%20only%20in%20Excel%3F%26nbsp%3B%20I%20am%20trying%20to%20store%20a%20partially%20locked%20Excel%20spreadsheet%20in%20One%20Drive%20and%20it%20is%20either%20all%20or%20nothing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2619825%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-2619870%22%20slang%3D%22en-US%22%3ERE%3A%20Need%20to%20Lock%20only%20certain%20cells%20(Excel)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2619870%22%20slang%3D%22en-US%22%3EFirstly%2C%20unlock%20all%20the%20cells%20in%20your%20worksheet%20by%20Pressing%20Ctrl%20%2B%201%26gt%3B%26gt%3BProtection%26gt%3B%26gt%3BUncheck%20Locked%20option.%20Next%20press%20the%20Control%20key%20and%20select%20all%20the%20cells%20you%20want%20to%20lock.%20Press%20Ctrl%2B1%26gt%3B%26gt%3BProtection%26gt%3B%26gt%3BLocked(checkmark%20the%20box).%20This%20will%20Lock%20the%20selected%20cells.%20Now%20you%20can%20protect%20your%20worksheet%20from%20the%20review%20tab.%20This%20will%20lock%20your%20selected%20cells%20only%3C%2FLINGO-BODY%3E
Occasional Visitor

How to lock certain cells only in Excel?  I am trying to store a partially locked Excel spreadsheet in One Drive and it is either all or nothing.

 

Thank you in advance.

1 Reply
Firstly, unlock all the cells in your worksheet by Pressing Ctrl + 1>>Protection>>Uncheck Locked option. Next press the Control key and select all the cells you want to lock. Press Ctrl+1>>Protection>>Locked(checkmark the box). This will Lock the selected cells. Now you can protect your worksheet from the review tab. This will lock your selected cells only