How to Protect a Worksheet but Unlock a Range

When working with Excel, you may need to protect your worksheet but leave a certain area unlocked. Please follow the steps below for details:

Step 1: Select the data range in the worksheet;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Format" in the Cells section, and select "Lock Cell" from the drop-down list;

Step 4: Click "Format" command again, and click "Protect Sheet"; in the "Protect Sheet" window, type in a password and click "OK" at the bottom;

Step 5: Re-type the same password in the "Confirm Password" window and click "OK" at the bottom.

Leave a Reply

72 Excel Shortcuts 
Print Version 
FOR FREE!!

Download this free Excel Shortcuts Cheat Sheet print version to save your time in your daily work!
Yes, I want it!
Subscribe to receive more excellent notes for free!
close-link