Prev: Open the world of Pivot Tables
Next: Columns disappeared
From: kbear34 on 17 Feb 2010 11:19
I'm trying to set up a form in Excel that will have text entered by other
people. There's a section of cells that I would like to set the row height
to autofit to wrapped text upon data entry. I've set the autofit row height
on a cell with wrapped text checked and tested it and the row height does not
change. Can anyone help with this, please?
From: Gord Dibben on 17 Feb 2010 12:32
Do you any merged cells in your form?

They will no respond to row autoheight.

Either get rid of them or you will need VBA code to deal with them.

For the code.................

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/2293ac4e6373c4d3/ca1c160cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 08:19:02 -0800, kbear34
<kbear34(a)discussions.microsoft.com> wrote:

>I'm trying to set up a form in Excel that will have text entered by other
>people. There's a section of cells that I would like to set the row height
>to autofit to wrapped text upon data entry. I've set the autofit row height
>on a cell with wrapped text checked and tested it and the row height does not
>change. Can anyone help with this, please?

 | 
Pages: 1
Prev: Open the world of Pivot Tables
Next: Columns disappeared