SOLVED
Home

excel locking issues

%3CLINGO-SUB%20id%3D%22lingo-sub-285752%22%20slang%3D%22en-US%22%3Eexcel%20locking%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285752%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20I%20lock%20an%20excel%20sheet%2C%20but%20leave%203%20cells%20editable%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-285752%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%3CLINGO-SUB%20id%3D%22lingo-sub-285808%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20locking%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285808%22%20slang%3D%22en-US%22%3EOf%20course!%20By%20default%20all%20cells%20are%20marked%20as%20locked.%20Unlock%20the%20cells%20you%20want%20to%20grant%20access%20to%20(right-click%2C%20Format%20Cells%2C%20Protection%20tab%2C%20uncheck%20%22locked%22).%20Then%20to%20invoke%20locking%20all%20cells%20but%20the%20ones%20you%20unlocked%2C%20you%20must%20protect%20the%20worksheet%20(Review%2C%20Protect%20Sheet%20button)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-684804%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20locking%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BI%20still%20can't%20get%20only%20particular%20cells%20to%20lock.%26nbsp%3B%20It's%20either%20the%20entire%20worksheet%20is%20locked%20or%20the%20entire%20worksheet%20is%20unlocked.%26nbsp%3B%20I%20only%20want%20to%20lock%205%20formula%20cells.%26nbsp%3B%20I%20want%20the%20remainder%20of%20the%20spreadsheet%20to%20remain%20editable.%26nbsp%3B%20Step%20by%20step%2C%20how%20is%20this%20accomplished%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687697%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20locking%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687697%22%20slang%3D%22en-US%22%3EBy%20default%20ALL%20cells%20are%20locked%2C%20so%20you%20only%20have%20to%20set%20cells%20which%20need%20to%20be%20edited%20to%20Unlocked%20and%20then%20protect%20the%20worksheet.%20Select%20all%20cells%20(control%2Ba%20multiple%20times%20until%20all%20cells%20are%20selected)%2C%20press%20control%2B1%20to%20open%20the%20cell%20formatting%20dialog%2C%20click%20the%20Protection%20tab%20and%20UNCHECK%20Locked.%20Now%20select%20the%20cells%20which%20need%20to%20be%20locked%2C%20then%20control%2B1%20again%2C%20this%20time%20check%20that%20box.%20Now%20protect%20the%20worksheet%20and%20you're%20good%20to%20go.%3C%2FLINGO-BODY%3E
Karina Lee
Occasional Visitor

Can I lock an excel sheet, but leave 3 cells editable? 

3 Replies
Highlighted
Solution
Of course! By default all cells are marked as locked. Unlock the cells you want to grant access to (right-click, Format Cells, Protection tab, uncheck "locked"). Then to invoke locking all cells but the ones you unlocked, you must protect the worksheet (Review, Protect Sheet button)

@Jan Karel Pieterse   I still can't get only particular cells to lock.  It's either the entire worksheet is locked or the entire worksheet is unlocked.  I only want to lock 5 formula cells.  I want the remainder of the spreadsheet to remain editable.  Step by step, how is this accomplished

By default ALL cells are locked, so you only have to set cells which need to be edited to Unlocked and then protect the worksheet. Select all cells (control+a multiple times until all cells are selected), press control+1 to open the cell formatting dialog, click the Protection tab and UNCHECK Locked. Now select the cells which need to be locked, then control+1 again, this time check that box. Now protect the worksheet and you're good to go.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies