Auto expand Row when typing lenthy text

[Zyphon]

I am trying to have a form that people can fill in and I know it would be far better to use Word for this purpose but it looks so much better in Excel format. The problem is I have merged about 10 cells in a row and copied this format down a few rows.

Now although I have set the 'Text Wrap' option the rows will not auto expand unti to accodate all the text unless I do a ALT-ENTER combo. The problem is anyone using this spreadsheet to complete the form may not know how to use this feature.

Is there anyway Excel can expand automatically or do I need some sort of Macro based in the Worksheet that will automatically adjust the row if the text is too long to fit?

Thanks in advance for any help offered.

[MickG]

Hi, This might help !

Please Login or Register  to view this content.

Regards Mick

[shg]

Zyphon,

What font are you using?

[Zyphon]

@MickG

Thanks for the Macro it works great! I did have to change it from Columns to Rows though as it is the rows that need expanding.

Zyphon,

What font are you using?

I am using Ariel size 10, does this have an impact?

Thanks.

[shg]

Excel can't autofit row heights for merged cells, but if it's working for you, ...

[Zyphon]

Excel can't autofit row heights for merged cells, but if it's working for you, ...

Thanks for your help, I appreciate your input. I ended up using Text Boxes as this seemed to work well. The problem is some people will want to print the form and complete it by hand and some will complete it electronically. For this reason I had to have a few blank rows so that it prints correctly. I think I can live with the result.

Thanks as always for your help guys.