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.