sorting+variable cell sizes
 

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

sorting+variable cell sizes
 

Select the several columns.

FormatRowAutofit.

FormatCellsAlignmentWrap Text.

Should work as you want when sorting



Gord Dibben MS Excel MVP

On Mon, 21 Apr 2008 16:34:45 -0700, "BobG" wrote:

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

sorting+variable cell sizes
 

Thank you Gord. That solved the problem.
Bob G

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Select the several columns.

FormatRowAutofit.

FormatCellsAlignmentWrap Text.

Should work as you want when sorting



Gord Dibben MS Excel MVP

On Mon, 21 Apr 2008 16:34:45 -0700, "BobG"
wrote:

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

sorting+variable cell sizes
 

Good to hear.

Thanks for the feedback

On Tue, 22 Apr 2008 17:58:32 -0700, "BobG" wrote:

Thank you Gord. That solved the problem.
Bob G

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Select the several columns.

FormatRowAutofit.

FormatCellsAlignmentWrap Text.

Should work as you want when sorting



Gord Dibben MS Excel MVP

On Mon, 21 Apr 2008 16:34:45 -0700, "BobG"
wrote:

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