Hide formular without any effect to other cell

[KIM Chanthan]

Hi dear,

Do you have any method to hide formula without any effect to other cell.
For example, I want to hide formula in A2, So everyone cannot do any change or see my formula in A2, but they still can see and edit other cell beside A2.

Thanks for help.

 

[Nebu]

Hi:

right click on a2-> select format cells-> on the protection tab check hidden and protect the workbook, the formula will not be visible.

Thanks

 

[KIM Chanthan]

Hi:

right click on a2-> select format cells-> on the protection tab check hidden and protect the workbook, the formula will not be visible.

Thanks

But if we protect worksheet, other cell will be protected too. my point is I don't want to protect any cell beside A2.

Thank.

 

[Nebu]

Hi:

Go through the following link , it will tell you how to protect a specific cell.

http://www.excel-easy.com/examples/lock-cells.html

Thanks