Locking cells?

  • Thread starter Thread starter Zerex71
  • Start date Start date
Z

Zerex71

Greetings,

I know this is probably a simple thing, but how do I lock or protect
cells which I do not want the user to modify? For example, if I allow
the user to enter data into cells A and B but C uses a function to
calculate the result of A and B, I want to lock the result cell so they
cannot accidentally enter data into C. How can I do this in Excel?

Mike
 
Cells can be locked or unlocked. Unless you've changed some settings, the
default for each cell is locked.

You can lock/unlock cells by:
selecting the cells
format|Cells|protection tab
check locked or unlocked

But the "lockedness" of a cell doesn't do much of anything until the worksheet
is protected. This can be set via:

Tools|Protection|protect sheet
(Remember the password you used)

But this kind of protection isn't very strong. It's easily broken by anyone who
knows enough to search google.

And there are lots of things that can't be done on a protected worksheet. You
may want to see if anything you really, really need is disabled when you protect
the sheet.
 
Hi
By default, all cells are 'locked', which is implemented by using
Tools>Protection>Protect Sheet.
Select the cells you don't want to lock, from Format Cells>Protection tab,
and then protect your sheet.

Andy.
 
Back
Top