Hiding formula

Closed
vishnugj
Posts
10
Registration date
Monday May 3, 2010
Status
Member
Last seen
April 14, 2015
- Jun 16, 2010 at 12:57 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Jun 10, 2014 at 10:54 AM
Hello,

Can you please guide me how to hide / protect formula from other users in an excel?

3 replies

That is easy. Click on the cell wher formula is located,
hit ctrl+1 then click on protection tab from the pop up. and then check the box in ffront of Locked and Hidden respectively. and click on OK, then protect the sheet. The formula will be hidden for view
0
jimwatt0351
Posts
2
Registration date
Sunday June 8, 2014
Status
Member
Last seen
June 9, 2014

Jun 9, 2014 at 10:19 AM
when hit ctrl+1 no window pop up
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Jun 10, 2014 at 10:54 AM
Hi Jim,

The pop up Chris is talking about is called "Cell properties". Another way of making it appear is right-clicking a cell(s) and selecting cell properties from the list.

Best regards,
Trowa
0
if you do not understand that then please let me know
0
Could you please look into this excel and suggest me how to hide formula in this attached excel?

https://authentification.site/files/22998184/example_1.xls

Please use this link for excel.
0