Wrap text in merged cells

  • Thread starter Thread starter Michael Beckinsale
  • Start date Start date
M

Michael Beckinsale

Hi,

I have a complicated spreadsheet which results in a nicely presented report
in which l need the user to input some narrative. To preserve the look and
feel of the report l would like the user to be able to input the narrative
on a single row, restricted to say 6 columns. The row height needs to adjust
automatically dpendent on the amount of text entered.

It seems a simple problem but l have tried many methods without success.

Anybody got any idea's on how to do this ?

All replies greatly appreciated.

Regards

Michael Beckinsale.
 
You have a problem because:
and
Click to expand...

are mutually exclusive. You can get the "6 columns" using a merged cell but
merged cells do not auto-fit row heights, unlike a single (non-merged) cell
with text wrap turned on.

Can you go with a width columned single cell? How about a text box from the
Drawing toolbar? It will not "auto-fit" per se, but maybe you can draw one
that limits the user to a reasonable amount of text.
 
Jim,

Many thanks for that. I suggested the same to the users but they were
adamant that they only wanted text boxes of the appropriate size because of
presentation. Also because of the complicated nature of the workbook the
sheet is protected and that would not lend itself easily to text boxes.

Any idea if it could be done using VBA coding ?
 
Back
Top