View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default how do I lock certain cells from getting edited

By default all cells in a worksheet are locked but this only becomes
effective if the worksheets is prorected. So, unlock cells you want to change
by right click - format - protection and remove the check mark from locked.
Protect the sheet using Tools - Protection - protect sheet and your done.

Mike

"sahishnu" wrote:

How do I lock certain cells from getting edited accidentally, while I work on
other cells in the same sheet