How to prevent editing within a specific cells?

  • Thread starter Thread starter Eric
  • Start date Start date
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
 
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 value within string? 10
How to change color within string? 2
How to determine the value within specific cell position? 5
How to retrieve text within ()? 13
How to count the number of occurrence within string? 2
How to define blank cell? 4
How to retrieve the values within cells? 4
How to set the formula? 5

Back
Top