Wrapping multiline text in merged cells


Rob Y

I'm trying to insert an arbitrary multiline comment string into an XLS
row and have bumped into a catch-22.

I originally tried merging a bunch of cells (all the defined columns in
the sheet for the row in question) and sticking the text into the first
of them. The point is that I don't know how wide the text is, and I
only want it to wrap where there are explicit newline characters.

This 'works', in the sense that the text appears in the cell and wraps
at the newlines. But I can't get Excel to auto-fit the row size to the
text. Even when I click 'format cells', I don't get the alignment tab
that would allow me to view the 'wrap text' option. If I manually
resize the row, the wrapping text displays fine.

So I tried it without the cell merge. Now it sizes the row to display
all the text, but it wraps to the single cell width, which means it
wraps to more lines than requested by the newlines.

I also tried cell merge without 'wrap text'. In that case, it just
ignores the newlines (displays them as 'bad character' glyphs).

So, is it possible to insert a big chunk of wrapping text into a big row
and get Excel to size the row so all the text displays?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question