How to hide formula

[shaileshgavanang]

Dear All

how to hide formula?

please help.

thank you

[npamcpp]

Select the cell, open the format dialog and on the Protection tab tick the box for "Hidden". Then click the Review ribbon and select "Protect sheet". Now the formula cannot be seen.

You can use a password to protect the sheet, so only people who know the password can unprotect it and see the formula.

Be aware that sheet protection is easy to circumvent for people who want to take the effort.