formula

[paul_pearson]

Hi

I have a formula in cell C13 in which i would like to protect only this cell in the spreadsheet so no-one can change.Also another posibility can i make the formula invisible so no-one see it?

Can both these be possible?

Thanks

Paul
Excel 2010<!-- google_ad_section_end -->

 

[Akashwani]

Hi Paul,

Yes you can do that.
This is what I would do...
Click between 1 and A in the top left of your sheet.
Right click anywhere on your sheet.
Click Format Cells.
Click Protection.
Uncheck the Locked box.
Click Ok.

Click cell C13
Right click.
Click Format Cells.
Click Protection.
Check the Locked box.
Check the Hidden box.
Click Ok.

Protect your sheet...
Click the Review tab.
Click Protect Sheet.
Enter your Password etc.

I hope that helps.

Ak

 

[paul_pearson]

Hi AK

Thank you and works well

Paul

 

[Akashwani]

Hi Paul,

I'm pleased it worked for you and thanks for the feedback.

Ak