Hiding Formula

Closed
vishnugj - Jun 17, 2010 at 12:38 PM
closeup22 Posts 8923 Registration date Friday May 15, 2009 Status Member Last seen October 7, 2010 - Jun 17, 2010 at 01:12 PM
Hello,

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.

1 response

closeup22 Posts 8923 Registration date Friday May 15, 2009 Status Member Last seen October 7, 2010 2,099
Jun 17, 2010 at 01:12 PM
Hi there,

To hide the formulas ,start by selecting all cells on the sheet going to menu bar selecting format cells>protection tab> unselect all which are locked in this menu then press on ok,now next step is to select only cells containing formulas,same steps again that is format >cells>protection>select the items which were previously unselected then press on ok.

Thanks
0