View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Locking content, formula, and format in a cell

Hi,
Protecting the sheet, but first you have to ensure Protection in the cell is
set up to locked
go to the cell, right click on the mouse, format cell, protection, check
Locked box, then protect your sheet. Nobody will be able to do anything in
that cell just read it

"Jess" wrote:

Is there anyway to lock the content, format, and formula -separately or
jointly- of a given cell? If so, how