How to prevent editing within a specific cells?

E

Eric

Does anyone have any suggestions on how to prevent editing within a specific
cells?
For example, in cell A1, there is a formula, =B1+C2. I don't want to delete
this formula accidently, but I still can see this formula. Does anyone have
any suggesitons on how to do it in excel?
Thanks in advance for any suggestions
Eric
 
A

Andy

Have you looked into the protection features in Excel? Under Tools, there is
a Protect sheet feature. The help topic covers all the different options you
have, but this may get you what you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to retrieve the values within cells? 4
How to change color within string? 2
How to change the font size for check box? 3
How to retrieve the value within string? 10
How to create a customized icon for specific filename within toolb 4
How to retrieve text within ()? 13
How to count the number of occurrence within string? 2
How to determine the value within specific cell position? 5

Top