Hide the formula of cell in worksheet

Sometime you required to hide the formula  in excel sheet.

Firstly, un-protect your sheet and right click the cells where you want to hide the formula  and click 'Format cells'. On the protection tab select the 'Locked' checkbox and then re-protect your sheet and the formula will not show up in the formula bar.

Comments