Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically set rows with cells with text wrapping to change
I just experimented with this scenario.
Merged a few cells in rows above. Put some text into a cell in a row below these. Wrap text and Autofit work OK on that row. Do you get any movement at all when you autofit that row or does it absolutely refuse to change height? If that row has been manually set to a height, it won't re-size until you go back and re-format to Autofit. Gord Dibben Excel MVP On Thu, 8 Dec 2005 07:58:03 -0800, cbizic wrote: Hello, Thanks for the information. There are merged cells in other rows above this in the columns that the row appears in (But not in the row the problem is occurring in). Would this affect it? cb "Gord Dibben" wrote: Do you have any "merged" cells in the rows? Autofit does not work on wrapped text in "merged" cells. You can resize manually or via Macro. Jim Rech has written code for this. http://groups.google.com/groups?thre...%40tkmsftngp05 Also revised code for special cases. http://snipurl.com/dfsm The best cure is DON"T USE MERGED CELLS. They cause no end of problems with copying, pasting, sorting, filtering. Gord Dibben Excel MVP On Wed, 7 Dec 2005 11:50:01 -0800, cbizic wrote: When formatting a cell with text wrapping, the row is not automatically increasing in height to account for extra text. Therefore, some text is hidden. Is there something that can be done while formatting for wrapping so that this will not occur. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
How do I change all cells to Proper text in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
How do I make rows expand to fit wrapped text in cells? | Excel Discussion (Misc queries) | |||
How to code so cells or text automatically change color based on . | Excel Worksheet Functions |