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
Highlighted
Deleted
Not applicable

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)
Highlighted

@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
Power Query/Pivot - Hours not in chronological order
Shahria3 in Excel on
0 Replies
How to add scale breaks in an Excel graph?
Ruben805 in Excel on
0 Replies
Tabellenbereich dynamisch erweitern oder reduzieren?
TheSoulrester in Excel on
0 Replies
Help with data valiation (indirect function)
novakdz in Excel on
0 Replies
Sous totaux excel
Artus _Ophlie in Excel on
0 Replies
How do I lock a excel file that is password protected
dogacakdag in Excel on
3 Replies