How to protect the cell's formula not be deleted

  • Thread starter Thread starter Man Utd
  • Start date Start date
M

Man Utd

I have formula in cells, how can I protect this formula from being deleted
when the user select this cell and delete the content.

eg.
in cell C10, the formula is =A10 * 2

If the A10 has value of 10, then C10 will be 20.
If the user select A10 and delete the content 20, then the formula will also
be deleted.
How do I prevent that ?
 
Select all cells
Format > cells > protection > Uncheck Locked
Select the cell with formula
Format > cells > protection > Check Locked
Tools > Protection > Protect sheet (password is optional)

Mangesh
 

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

Variable Sumproduct Range 6
use cell text in lookup function 3
Combining SUMIF and SUBTOTAL 4
Return an absolutely empty cell ... but not "" 3
adding/omitting/all the values prior to todays date 2
count - but exclude counting cells with a formula 4
Vlookup giving #N/A 12
How do i find last not empty cell in a range 9

Back
Top