full cell text

[greg]

hello,
i am wondering what the proper "format cell" alignment values should be used
to see all of the text in a cell. When you want the cell to grow vertical
when more text is added to the cell.
i click wrap text, for horizontal i use justify, or fill.
it always seems there is some cell, that whatever i fill in for the
alignment values that the text gets lost in the cell.

thanks

 

[Earl Kiosterud]

Greg,

I think you want the row height to grow or shrink automatically as more text
is added or removed. Set the cell to Wrap Text, as you did, and set the row
for autofit (Format - Row - Autofit). If you've even once set the row
height manually, it turns off Autofit; you have to turn it back on.

 

[greg]

thanks,
the autofit is good.

Greg,

I think you want the row height to grow or shrink automatically as more text
is added or removed. Set the cell to Wrap Text, as you did, and set the row
for autofit (Format - Row - Autofit). If you've even once set the row
height manually, it turns off Autofit; you have to turn it back on.