View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
Posts: 376
Default in MS EXCLE how we can protect only one cell?

Hi

First select all of the cells in the
SheetFormatCellsProtectionremove the check mark form Locked.
Next select the single cell you want to be
lockedFormatCellsprotectioncheck Locked.
ToolsProtectionProtect Sheet (optionally provide a password - remember
to write it down somewhere of you do)
--
Regards
Roger Govier

anu khan wrote:
plz do repl me soon