How to Protecting Formulas in Cells
How to Protecting Formulas in Cells
Protecting a cell or a group of cells prevents writing, editing or deleting the cell, or damaging the formula. Two conditions must be met to protect a cell: the cell must be locked, and the sheet must be protected.
Locking, the first condition
Select a cell in the sheet and press Ctrl+1. In the Format Cells dialog box, select Protection. Select the Locked option.
Select a cell in the sheet and press Ctrl+1. In the Format Cells dialog box, select Protection. Select the Locked option.
Protecting formulasProtecting formulas requires isolating cells with formulas from the rest of the cells in the sheet, locking them and then protecting the sheet.
Stage 1 – Canceling the locked format of all the cells in the sheet1. Select all the cells in the sheet by pressing Ctrl + A.
2. PressCtrl+1.
3. Select the Protection tab.
4. Clear the selection of the locked option. C
5. Click OK.
2. PressCtrl+1.
3. Select the Protection tab.
4. Clear the selection of the locked option. C
5. Click OK.
Stage 2 – Selecting cells with formulas1. Press F5.
2. Click Special.
3. Select the Formulas option.
4. Click OK.
2. Click Special.
3. Select the Formulas option.
4. Click OK.
Stage 3 – Locking cells with formulas1. PressCtrl+1.
2. Select the Protection tab.
3. Select the Locked option.
4. Click OK.
2. Select the Protection tab.
3. Select the Locked option.
4. Click OK.
Stage 4 – Protecting the sheet1. From the Review menu, select Protection, Protect sheet.