"read only" cell in a given worksheet

C

Colin2u

is it possible to have a particuler cell in a worksheet to be only "read
only"? meaning to hae that cell be read and not to be edited be others (even
preventing the view of that cell's formula).
thank you.
 
D

Doug Kanter

Colin2u said:
is it possible to have a particuler cell in a worksheet to be only "read
only"? meaning to hae that cell be read and not to be edited be others
(even
preventing the view of that cell's formula).
thank you.
Click to expand...

Click on Format, Cells, and then look at the Protection tab. You'll see two
options: locked and hidden, along with a brief explanation of what's what,
as well as the limitations of the features. This may or may not do what you
need.
 
P

Phil

But don't forget that you need to protect the worksheet before the
locking actually happens.

Phil
 
Top