How to hide formula

Closed
Ann - Oct 19, 2011 at 05:35 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 19, 2011 at 06:16 AM
Hello,

If i have one formula inserted in Excel and when i will send the same sheet to someone, I do not want the other person to see the formula.

I just wanted the other person to fill the data in the required field then excel should automatically provide the output in the formula inserted cell.

How to hide the formula as well as it should work also.

Would appreciate if anyone can help me in this.

Thanks.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 19, 2011 at 06:16 AM
Perhaps one way would be to protect the sheet and lock that cell
0