Worksheet Protection

Are there parts of the worksheet that you want protected? For instance you may want to protect cells that contain formulae. If that is what you intend to do, then Worksheet Protection is the answer.

Worksheet Protection prevents a user from accidentally or deliberately changing, moving, or deleting important data from a worksheet or workbook. You can protect certain worksheet  or workbook elements, with or without a password . You can then remove the protection from a worksheet as needed. In the example below we show you how to protect the entire worksheet except the data range C5:C7. 

Applies To: MS Excel 2003, 2007, 2010 

  1. This tip will be based on the screen shot below

2.  Unlock cells:

a.  Select the range C5:C7
b.  On the Home tab, in the Cells group, select Format
c.  Select Lock Cell

 3.  Protect the worksheet:

a.    On the Home tab, in the Cells group, select Format
b.  Select Protect Sheet
c.  De-Select the option-Select Locked Cells
d.  Add a password
e.  Select OK

4.  You will only be able to select the cells in the range C5:C7

a.  The formulas cannot be edited or deleted.(C5:D7)

5.  To Un-protect the worksheet

a.  On the Home tab, in the Cells group, select Format
       b.  Select Unprotect Sheet
       c.Enter a password if required



If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.


Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations