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 How to hide a particular cell.......

You can hide the entire column or entire row.

You can format the cell to use the same color font as fill (white font on white
fill)

You can use a custom format of:
;;;

The last two options make the cell look empty, but you can still see the value
in the formula bar.

PSL wrote:

Hi,

Shall I hide a particular cell after entering the data either it is a Text
or Number.

Narayan PSL


--

Dave Peterson