SOLVED

Easy way for Protecting sheets and allowing an editable cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2322736%22%20slang%3D%22en-US%22%3EEasy%20way%20for%20Protecting%20sheets%20and%20allowing%20an%20editable%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2322736%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20an%20easy%20way%20to%20protect%20a%20sheet%20and%20allow%201%20cell%20to%20be%20editable%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2322736%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2323173%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20way%20for%20Protecting%20sheets%20and%20allowing%20an%20editable%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1044914%22%20target%3D%22_blank%22%3E%40Billwheels55%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStep%201%3A%20unlock%20cell.%3C%2FP%3E%0A%3CP%3ESelect%20the%20cell%20that%20you%20want%20to%20be%20editable.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2B1%20to%20activate%20the%20Format%20Cells%20dialog.%3C%2FP%3E%0A%3CP%3EActivate%20the%20Protection%20tab.%3C%2FP%3E%0A%3CP%3EClear%20the%20Locked%20check%20box.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStep%202%3A%20protect%20sheet.%3C%2FP%3E%0A%3CP%3EActivate%20the%20Review%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EClick%20'Protect%20Sheet'.%3C%2FP%3E%0A%3CP%3EUse%20the%20check%20boxes%20to%20specify%20what%20the%20user%20can%20do.%20At%20the%20very%20least%2C%20leave%20the%20check%20box%20'Select%20unlocked%20cells'%20ticked.%3C%2FP%3E%0A%3CP%3EIf%20you%20wish%2C%20enter%20a%20password%20that%20will%20be%20needed%20if%20you%20want%20to%20unprotect%20the%20sheet%20later%20on.%20Do%20not%20forget%20this%20password!%3C%2FP%3E%0A%3CP%3EClick%20OK.%20If%20you%20provided%20a%20password%2C%20you%20will%20have%20to%20re-enter%20it%20as%20comfirmation.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStep%203%3A%20save%20the%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there an easy way to protect a sheet and allow 1 cell to be editable?

Thanks!

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Billwheels55 

Step 1: unlock cell.

Select the cell that you want to be editable.

Press Ctrl+1 to activate the Format Cells dialog.

Activate the Protection tab.

Clear the Locked check box.

Click OK.

 

Step 2: protect sheet.

Activate the Review tab of the ribbon.

Click 'Protect Sheet'.

Use the check boxes to specify what the user can do. At the very least, leave the check box 'Select unlocked cells' ticked.

If you wish, enter a password that will be needed if you want to unprotect the sheet later on. Do not forget this password!

Click OK. If you provided a password, you will have to re-enter it as comfirmation.

 

Step 3: save the workbook.

@Hans Vogelaar 

 

Thank you! This is perfect!

 

Appreciate your help!

 

Wheels