Protection of Formula in a Spreadsheet

Asked By Alberto Lawrence 0 points N/A Posted on - 04/07/2012

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

• Status: Open
• Question Views: 803
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by rasika

Go To Solution

Answered By Gideon Yasti 15 points N/A #110663

Protection of Formula in a Spreadsheet

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.

About Gideon Yasti

Questions
3

Answers
316

Best Answers
69

• Vote Up 0 Vote Down

• Posted on - 04/07/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By rasika 0 points N/A #110665

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.

About rasika

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 05/28/2012
• Question Category: MS Excel