Thread: Lock cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Lock cell

Select all the cells
format|cells|protection tab|check unlocked
select just the single cell you want locked
format|cells|protection tab|check locked

And for that locked cell to be treated as locked, you'll need to protect the
worksheet:
tools|protection|protect sheet

(be aware that worksheet protection is easily broken--don't rely on this to
protect your intellectual property.)

teddi wrote:

how can i lock only one cell in my worskeet???


--

Dave Peterson