Protection of Formula in a Spreadsheet

Asked By 0 points N/A Posted on -
qa-featured

How can I protect the formula I made in some cells of a spreadsheet to prevent changes and conflict?

SHARE
Best Answer by rasika
Answered By 0 points N/A #110663

Protection of Formula in a Spreadsheet

qa-featured

If you already developed a spreadsheet in MS Excel, you may protect your formulas which are you applied in your spreadsheet by hide or lock formula.

If you want to lock any cell in your own spreadsheet then just click on the Format in menu then choose Cells then select the Protection tab. Now clear the Locked check box and then select OK.

If you want to protect your sheet then select Tools in menu and then select Protection then iSheet. You will get an option for enter password for protect your sheet from stranger. It is a better policy for make privacy in your spreadsheet.

Thanks.

Best Answer
Best Answer
Answered By 0 points N/A #110665

Protection of Formula in a Spreadsheet

qa-featured

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.

Login/Register to Answer

Related Questions