You are here KNOWLEDGE Excel Tips Excel Text, Editing and Format Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007

Query, Share and Manage Excel workbooks on LAN, Internet

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.