Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell sizes | Excel Worksheet Functions | |||
Excel: want header cell sizes to differ from the other sheet cell. | Excel Discussion (Misc queries) | |||
Modify Cell Sizes | Excel Worksheet Functions | |||
how do I add another page with different cell sizes? | Excel Worksheet Functions | |||
Sorting merged cells of differant sizes | Excel Discussion (Misc queries) |