Tip Printed from ExcelTip.com

---

Protecting Cells in the Sheet in Excel 2007


Protecting cells in the sheet means that the contents of cells cannot be changed and/or formulas can be hidden from view.

To protect cells in the sheet:

Step 1: Locking the cells:
1. Press Ctrl+1 and select the Protection tab in the Format Cells dialog box.
2. Select the Locked checkbox and click OK.

Step 2: Protect a sheet:
Select Review - Protect Sheet (in Changes Group)
Or
1. Select the sheet tab, right click and select Protect Sheet.
2. Enter a password and click OK.