Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How do I auto expand Cells to show all the wrapped text?
Trying to make row heights change to accommodate varying amounts of text
without manually adjusting the row height. Is there a setting I can use? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How do I auto expand Cells to show all the wrapped text?
FormatRowsAutofit with cells set to Wrap Text under FormatCellsAlignment
NOTE: if you are using "merged cells" autofit will not work and needs VBA event code to change row heights. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 17:22:00 -0700, DonnaTypes01 wrote: Trying to make row heights change to accommodate varying amounts of text without manually adjusting the row height. Is there a setting I can use? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How do I auto expand Cells to show all the wrapped text
Hi,
I done all but still not working Help Laisvune "Gord Dibben" wrote: FormatRowsAutofit with cells set to Wrap Text under FormatCellsAlignment NOTE: if you are using "merged cells" autofit will not work and needs VBA event code to change row heights. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 17:22:00 -0700, DonnaTypes01 wrote: Trying to make row heights change to accommodate varying amounts of text without manually adjusting the row height. Is there a setting I can use? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How do I auto expand Cells to show all the wrapped text
I don't see a reply to "Laisviak" last question, so I am replying in the
hope of getting an answer. I too have done all I can to adjust row height and wrap text, but it is not working. I have Outlook 2007, cells are all formated to Text, wrap, allignment general and top Some of the cells wrap and auto height the rows to show all of the text Some of the cells will not auto height the rows and if I manually expand the row using my cursor, the text still does not show. It only shows when I double click the cell. I have hightlighted all rows and chose auto-row height and still some cells will not adjust. Thanks "Laisviak" wrote: Hi, I done all but still not working Help Laisvune "Gord Dibben" wrote: FormatRowsAutofit with cells set to Wrap Text under FormatCellsAlignment NOTE: if you are using "merged cells" autofit will not work and needs VBA event code to change row heights. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 17:22:00 -0700, DonnaTypes01 wrote: Trying to make row heights change to accommodate varying amounts of text without manually adjusting the row height. Is there a setting I can use? Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How do I auto expand Cells to show all the wrapped text
"AnnieB" wrote: I don't see a reply to "Laisviak" last question, so I am replying in the hope of getting an answer. I too have done all I can to adjust row height and wrap text, but it is not working. I have Outlook 2007, cells are all formated to Text, wrap, allignment general and top Some of the cells wrap and auto height the rows to show all of the text Some of the cells will not auto height the rows and if I manually expand the row using my cursor, the text still does not show. It only shows when I double click the cell. I have hightlighted all rows and chose auto-row height and still some cells will not adjust. Thanks "Laisviak" wrote: Hi, I done all but still not working Help Laisvune "Gord Dibben" wrote: FormatRowsAutofit with cells set to Wrap Text under FormatCellsAlignment NOTE: if you are using "merged cells" autofit will not work and needs VBA event code to change row heights. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 17:22:00 -0700, DonnaTypes01 wrote: Trying to make row heights change to accommodate varying amounts of text without manually adjusting the row height. Is there a setting I can use? Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How do I auto expand Cells to show all the wrapped text
I'm having the same problem as AnnieB. Have auto row height set, word wrap,
etc. Have not maxed out in the # characters/cell. Auto height worked when only approx 50 characters, but now, as more text added, only getting the #### error -- even when manually increasing the row height. Can see the actual text when the cell is double clicked. Please - does someone have a solution? Am using home version Excel 2007 and Vista OS. "AnnieB" wrote: I don't see a reply to "Laisviak" last question, so I am replying in the hope of getting an answer. I too have done all I can to adjust row height and wrap text, but it is not working. I have Outlook 2007, cells are all formated to Text, wrap, allignment general and top Some of the cells wrap and auto height the rows to show all of the text Some of the cells will not auto height the rows and if I manually expand the row using my cursor, the text still does not show. It only shows when I double click the cell. I have hightlighted all rows and chose auto-row height and still some cells will not adjust. Thanks "Laisviak" wrote: Hi, I done all but still not working Help Laisvune "Gord Dibben" wrote: FormatRowsAutofit with cells set to Wrap Text under FormatCellsAlignment NOTE: if you are using "merged cells" autofit will not work and needs VBA event code to change row heights. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 17:22:00 -0700, DonnaTypes01 wrote: Trying to make row heights change to accommodate varying amounts of text without manually adjusting the row height. Is there a setting I can use? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells with wrapped text won't auto-adjust row height correctly | Excel Discussion (Misc queries) | |||
How can I get excel to show ALL lines of wrapped text? | Excel Worksheet Functions | |||
Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
How do I make rows expand to fit wrapped text in cells? | Excel Discussion (Misc queries) | |||
How do I automatically expand a merged cell with wrapped text? | Excel Discussion (Misc queries) |