Protection of Formula in a Spreadsheet

Protection of Formula in a Spreadsheet

You can easily protect the formulas that you made in particular cells to prevent changes.

1. If you want to protect only the cells which include formulas:

• Select the entire spreadsheet. (Click the select all button.ie. Rectangular in the upper left corner)
• Write click and click format cell & click on the Protection tab.
• Clear the Locked check box and click ok.
• Then select the cells which include formulas.
• Write click and click format cell & click on the Protection tab.
• Tick the Locked check box and click OK.
• On the Review tab, in the Changes group, click Protect Sheet.
• In the Password to unprotect sheet box, type a password for the sheet, click OK, and then retype the same password to confirm it.
• Now the cells which include fomulas cannot be changed.

2. If you want to protect the entire spreadsheet:

• Select the entire spreadsheet.(Click the select all button.ie. Rectangular in the upper left corner)
• Write click and click format cell & click on the Protection tab.
• Checked whether the Locked check box is ticked. (If not tick the locked check box)
• Click OK.
• On the Review tab, in the Changes group, click Protect Sheet.
• In the Password to unprotect sheet box, type a password for the sheet, click OK, and then retype the same password to confirm it.
• Now data or formulas in cells cannot be changed.