FormatCellsAlignment tab, check Wrap text

--
Kind regards,

Niek Otten

"Siwelile" wrote in message
...
i want to know do i make my text fit into 1 block if it is a long sentance
needing two or three lines . pressing enter in the fromula bar doen't
work.