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
Post a Comment