You can select all cells. (Ctrl+A) and then try
--
If this post helps click Yes
---------------
Jacob Skaria


"Charlene Lee" wrote:

I thought i had formatted each cell but if i type in the cell directly the
formatting is lost but if I type the text in the upper area the formatting is
still there............

thx to all

char