sorting+variable cell sizes

[BobG]

I am developing a worksheet that has several columns. All but one of these
colums has cells of constant height. (Date, Name, Address etc. The
remaining column has cells that can have more that one line of text. All
columns have WordWrap "on" so when the text column contains more than one
line of text the whole spreadsheet line increase in height. In other words
everything is fine. The problem is that I need to sort the data by Date Name
or Adress and can't get the sorted list to apply the wordwrap to the text in
the new cell location and cause the cells to expand in height as required. I
would be most grateful if anyone could tell me how to solve this problem.
BobG

 

[Gord Dibben]

Select the several columns.

Format>Row>Autofit.

Format>Cells>Alignment>Wrap Text.

Should work as you want when sorting



Gord Dibben MS Excel MVP

 

[BobG]

Thank you Gord. That solved the problem.
Bob G

Select the several columns.

Format>Row>Autofit.

Format>Cells>Alignment>Wrap Text.

Should work as you want when sorting



Gord Dibben MS Excel MVP

 

[Gord Dibben]

Good to hear.

Thanks for the feedback

Thank you Gord. That solved the problem.
Bob G