SOLVED

How to lock cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2029040%22%20slang%3D%22en-US%22%3EHow%20to%20lock%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029040%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20would%20like%20to%20ask%20for%20help%20with%20my%20excel%20file.%20I%20would%20lock%20to%20lock%20formatting%2C%20deleting%2C%20or%20typing%20on%20all%20cells%20except%20the%20cells%20filled%20with%20the%20color%20green.%20How%20can%20I%20do%20this%3F%20Thank%20you%20for%20helping!%20Can%20I%20also%20get%20the%20step%20by%20step%20procedure%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2029040%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2029162%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20lock%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029162%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F864901%22%20target%3D%22_blank%22%3E%40lavita17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20a%20two-step%20process.%20By%20default%2C%20all%20cells%20are%20locked%20but%20this%20only%20becomes%20effective%20when%20you%20protect%20the%20worksheet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EStep%201%3A%20unlock%20cells.%3C%2FSTRONG%3E%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ESelect%20the%20cells%20that%20the%20user%20should%20be%20able%20to%20edit.%20You%20can%20hold%20down%20Ctrl%20to%20select%20non-contiguous%20ranges.%3C%2FLI%3E%0A%3CLI%3EPress%20Ctrl%2B1%20to%20activate%20the%20Format%20Cells%20dialog.%3C%2FLI%3E%0A%3CLI%3EActivate%20the%20Protection%20tab.%3C%2FLI%3E%0A%3CLI%3EClear%20the%20Locked%20check%20box.%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSTRONG%3EStep%202%3A%20protect%20worksheet.%3C%2FSTRONG%3E%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EActivate%20the%20Review%20tab%20of%20the%20ribbon.%3C%2FLI%3E%0A%3CLI%3EClick%20'Protect%20Sheet'.%3C%2FLI%3E%0A%3CLI%3ETick%20the%20check%20boxes%20for%20the%20features%20the%20users%20should%20be%20permitted%20on%20unlocked%20cells.%3C%2FLI%3E%0A%3CLI%3EAt%20the%20very%20least%2C%20leave%20'Select%20unlocked%20cells'%20ticked%2C%20otherwise%20the%20user%20won't%20be%20able%20to%20do%20anything.%3C%2FLI%3E%0A%3CLI%3EIf%20you%20want%20to%20specify%20a%20password%20that%20will%20be%20needed%20to%20unprotect%20the%20sheet%2C%20enter%20it%20in%20the%20box.%20Do%20not%20forget%20the%20password!%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3CLI%3EIf%20you%20entered%20a%20password%2C%20you%20will%20be%20asked%20to%20enter%20it%20again%20as%20confirmation.%3C%2FLI%3E%0A%3CLI%3ESave%20the%20workbook.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2029170%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20lock%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F864901%22%20target%3D%22_blank%22%3E%40lavita17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20might%20be%20best%20served%20by%20this%20YouTube%20video%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DPiRVgAZnGGA%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DPiRVgAZnGGA%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20explains%20the%20process%20fully%2C%20and%20would%20enable%20you%20to%20implement%20it%20on%20your%20own.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi! I would like to ask for help with my excel file. I would lock to lock formatting, deleting, or typing on all cells except the cells filled with the color green. How can I do this? Thank you for helping! Can I also get the step by step procedure?

3 Replies
Best Response confirmed by lavita17 (Occasional Contributor)
Solution

@lavita17 

This is a two-step process. By default, all cells are locked but this only becomes effective when you protect the worksheet.

 

Step 1: unlock cells.

  1. Select the cells that the user should be able to edit. You can hold down Ctrl to select non-contiguous ranges.
  2. Press Ctrl+1 to activate the Format Cells dialog.
  3. Activate the Protection tab.
  4. Clear the Locked check box.
  5. Click OK.

Step 2: protect worksheet.

  1. Activate the Review tab of the ribbon.
  2. Click 'Protect Sheet'.
  3. Tick the check boxes for the features the users should be permitted on unlocked cells.
  4. At the very least, leave 'Select unlocked cells' ticked, otherwise the user won't be able to do anything.
  5. If you want to specify a password that will be needed to unprotect the sheet, enter it in the box. Do not forget the password!
  6. Click OK.
  7. If you entered a password, you will be asked to enter it again as confirmation.
  8. Save the workbook.

 

 

@lavita17 

 

You might be best served by this YouTube video https://www.youtube.com/watch?v=PiRVgAZnGGA

 

It explains the process fully, and would enable you to implement it on your own.

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentialsProtect your Excel formula cells to make sure they're not changed. Onl...

Thank you so much! This worked perfectly!