| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What controls row expansion to show muli-line text in a word-wrap
I seem to have difficulty when entering text into a cell and the row size not
expanding to show all of the data. I'm not talking about being beyond the character limits of a cell. I use word wrap for the cell but the row height doesn't enlarge to show all text entered. I've even tried Format, Row, AutoFit unsuccessfully. I have to go over to the far left and manually drag the row down to make it larger. Surely there's a way to have this occur automatically? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What controls row expansion to show muli-line text in a word-wrap
Are you using "merged" cells?
These will wrap text but will not autofit. You would have to use event code behind the worksheet to achieve autofitting. Gord Dibben MS Excel MVP On Wed, 18 Mar 2009 09:34:13 -0700, Bill45 wrote: I seem to have difficulty when entering text into a cell and the row size not expanding to show all of the data. I'm not talking about being beyond the character limits of a cell. I use word wrap for the cell but the row height doesn't enlarge to show all text entered. I've even tried Format, Row, AutoFit unsuccessfully. I have to go over to the far left and manually drag the row down to make it larger. Surely there's a way to have this occur automatically? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| word wrap without row expansion? | Excel Discussion (Misc queries) | |||
| Cells using wrap text will not show | Excel Discussion (Misc queries) | |||
| excel wrap text no show | Excel Discussion (Misc queries) | |||
| Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
| how can I wrap text from one line to another? | Excel Worksheet Functions | |||
Hybrid Mode
