Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007

To protect a cell containing any type of data, two conditions must be met:

Condition 1: The cell is locked:
1. Select a cell in the sheet and press Ctrl+1.
2. In the Format Cells dialog box, select the Protection tab.
3. Select the Locked checkbox and click OK.
Or
Select Home - Format (in Cells Group) - Lock.

Condition 2: The sheet is protected:
1. Select Review - Protect Sheet (in Changes Group).
Or
Right click the sheet tab and select Protect Sheet.
2. Click OK.

Protecting cells containing Text or Formulas, requires isolating the cells containing the type of different data from the rest of the cells in the sheet, locking them, and then protecting the sheet.

To select and protect different type of data:

Step 1: Change the lock to unlock of all the cells in the sheet:
1. Select all cells in the sheet by pressing Ctrl+A, or press Ctrl+A+A from a cell in the Current Region/List range.
2. Select Home - Format (in Cells Group) - Lock.
Step 2: Selecting cells containing text or formulas:
Select Home - Find & Select (in Editing Group) - Constants or Formulas.
Or
1. Press F5.
2. Click Special, and then select Constants (for text) or Formulas.
3. Click OK.
Step 3: Locking cells containing text or formulas:
Select Home - Format (in Cells Group) - Lock.
Or
1. Press Ctrl+1.
2. Select the Protection tab, and then select the Locked checkbox.
3. Click OK.
Step 4: Protecting the sheet:
1. Select Review - Protect Sheet (in Changes Group).
Or
Right click the sheet tab and select Protect Sheet.
2. Enter a password and click OK.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.