Auto Expand field for excessive text

[richrr31]

Is there a way to expand the height of a row if one of the cells info doesn't fit. I want a row of cells to display their information at all times. I know I can shrink the text to fit, but this makes the information difficult/impossible to read. I want it so that if there is four lines of text in a cell, that row expands to be four rows tall, so that all of the info is present.

 

[Damon Ostrander]

Hi Rich,

Just select the rows you want to re-size, then go to Format > Row > AutoFit.

 

[Juan Pablo González]

I think that you also have to check the "Adjust Text" checkbox on the second tab of the Cell format dialog.

 

[richrr31]

I am not too sure that this solution works. The form will be given to our users empty. When they begin to enter the info, I want the text to drop to the next line once the end of the cell is hit (Wrap text), but I want the text to be visible. I tried autofit, but that doesn't seem to work; the first line of text remains visible, and that's it.