formula

paul_pearson

Board Regular
Joined
Mar 3, 2013
Messages
181
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 -->
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
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
 

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
Hi Paul,

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

Ak
 

Watch MrExcel Video

Forum statistics

Threads
1,090,296
Messages
5,413,608
Members
403,494
Latest member
Adilson MAchado

This Week's Hot Topics

Top