Previous Topic Next Topic

How to hide formula

Closed
Ann - 19 Oct 2011 à 05:35
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 19 Oct 2011 à 06:16
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
19 Oct 2011 à 06:16
Perhaps one way would be to protect the sheet and lock that cell

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses