Protecting of cells

  • Thread starter Thread starter Graeme
  • Start date Start date
G

Graeme

Hi

Can someone help?

I have been doing a spreadsheet which has some pretty
complex formulas included in it. It will be used by
people who don't have a great understanding of excel and
all i want them to do is enter a value and allow the
program to make the calculations for it. If they delete
any formulas it may stuff the whole thing up.

My question:

Am I able to protect particular cells so that the
formulae and content cannot be altered?

Thanks
 
Yes. Look up Protection in Help. First you lock the cells to be locked (that's the default), or
unlock the cells where they can enter data. Then you protect the worksheet, perhaps with a
password.
 
Back
Top