How to lock and protect selected cells in Excel?
It's easy to lock and protect the whole worksheet or workbook with clicking the Protect Sheet button or Protect Workbook button under Review tab. However, sometimes you may need to lock and protect only specific cells or selections in a sheet. How would you like to do? This article will guide you to lock and protest selected cells or ranges in Excel with following steps:
Classic Menu for Office: Bring Back Old Look to Office 2010 and 2013 (includes Office 365).
Office Tab: Bring Tabbed Editing and Browsing Features to Office, Just Like Chrome, Firefox, Internet Explorer 8/9/10.
Step 1: Select all cells in current worksheet with pressing the Ctrl key and A key together.
Step 2: Right click, and select the Format Cell item from the context menu.
Step 3: In the Format Cells dialog box, uncheck the Locked option under Protection tab, and click OK button. See the following screen shot:
Step 4: Select cells and ranges that you want to lock.
Step 5: Right click selected ranges, and select the Format Cell item from the context menu.
Step 6: In the Format Cells dialog box, check the Lock option under Protection tab, and click OK.
Step 7: Click the Protect Sheet button in the Changes group under Review tab.
Step 8: In the Protect Sheet dialog box, enter a password in the blank box under Password to unprotect sheet:. See the following screen shot:
Step 9: Confirm Password dialog box pops up, please reenter the password again.
Step 10: Click OK.
Then it locks and protects only selected cells and ranges in current worksheet, while unselect ranges are editable.