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:
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu for Office: Brings Back Classic Menus and Toolbars to Office 2013, 2010 and 2007.
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.
Kutools for Excel
More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.
