Lock out cells

[Q45]

How do I lock out cells where I have put formulas so that someone else can't type over that cell? Thanks.

 

[Brian from Maui]

Go to Format/Cells, click on Protection. Then go to Tools/Protection/protect worksheet
This message was edited by Brian from Maui on 2002-04-05 07:48

 

[nancyo]

On the specific cell, right click. Select format, protection, and check off locked. In order for this to work, the worksheet must be protected (tools, protection, protect sheet, password, re-enter password).

 

[Q45]

I have done both of these things. It doesn't work. Am I missing something?

 

[Brian from Maui]

On the Protection tab, click lock and hidden, then protect the worksheet