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:

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 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:

shot-lock-cell-1

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.

shot-lock-cell-2

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:

shot-lock-cell-3

Step 9: Confirm Password dialog box pops up, please reenter the password again.

shot-lock-cell-4

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.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh