View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Hide the formula

Format|Cells|Protection tab:

If hidden is checked, it will hide the contents of the cell (i.e.: the
formula), when the sheet is protected.
If Locked is unchecked, it will allow the person to enter data intot he cell
when the sheet is protected.
--
John C


"Mat" wrote:

Hi,

How can i hide the formula in some cell and keep some cells free, so that we
can the enter the data.

Friend in need...

Mat