I have a row that I want the default height to be 45. Once of the cells
contains text that I want to auto adjust the height of if the text is too
long to fit at 45. Is this possible? If so could someone point me in the
right direction?

Thanks in advance..... E

As a matter of clearification.....

I have a spreadsheet that I have a radio button set in one cell, 3 buttons
vertically so for the radio buttons to appear properly I have to have a
minimum row height of 45. On either side of that column I have columns that
require user input as text. I want the row to adjust height, if the text
entered does not fit at the default height of 45. The issue with auto height
is that if I use auto height then the radio buttons get all distorted.

Is there something I can do either with the text columns or the radio button
function that would allow the height of the row to adjust as text is entered?

Auto fit with wrap text will work but it will auto adjust the height to
potentially be less than your required 45. To get around that use a helper
column. In one of the blank columns set the font size such that the cell
height is 45. This way the auto adjust can not be less than 45...
--
HTH...

Jim Thomlinson


"Eagle" wrote:

I have a row that I want the default height to be 45. Once of the cells
contains text that I want to auto adjust the height of if the text is too
long to fit at 45. Is this possible? If so could someone point me in the
right direction?

Thanks in advance..... E

Thanks Jim,

Worked like a champ.... Not something I would have thought about.... But
worked like a champ....

"Jim Thomlinson" wrote:

Auto fit with wrap text will work but it will auto adjust the height to
potentially be less than your required 45. To get around that use a helper
column. In one of the blank columns set the font size such that the cell
height is 45. This way the auto adjust can not be less than 45...
--
HTH...

Jim Thomlinson


"Eagle" wrote:

I have a row that I want the default height to be 45. Once of the cells
contains text that I want to auto adjust the height of if the text is too
long to fit at 45. Is this possible? If so could someone point me in the
right direction?

Thanks in advance..... E