PDA

View Full Version : How To Protect Hide Formula In Excel



paul_pearson
04-10-2013, 12:33 AM
Hi

I have a formula in cell C13 in which i would like to protect only this cell in the spreadsheet.Can this be done or can i make the formula invisible so no-one see it?

Thanks

Paul
Excel 2010

princ_wns
04-10-2013, 08:33 AM
Hi Paul,

Plz follow these steps.

1: Right Click on the cell choose format Cell-> Select Protection Tab->Select Hidden Option->ok
2: Protect the Sheet

This will hide the formulea on the sheet only result of the formula will be shown there

Regards
Prince