Select the row and do format=row and select autofit.

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi all,
I put the Cell1Add & char(10) & Cell2Add into another cell and the content
from Cell1 and Cell2 are put in seperate lines. The question is the
containing cell did not collapse automatically to display the multiple lines.

Clara


thank you so much for your help