Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapping text in merged cells
HELP - I'm formatting an Excel spreadsheet. I have some merged cells that
have text in it that I want to wrap. I've selected wrap text on the fomatting menu....and the text does wrap, but the cell doesn't expand to show the wrapped text? I've tried selecting the row and formatting it to "auto fit", but that doesn't work either. How do I get the cell to expand to show that wrapped text? I'm open to just about anything at this point. Any help is appreciated. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapping text in merged cells
Unfortunately, you're experiencing one of the trade offs using merged cells,
and you're left with having to resize the row manually. Personally, I try to avoid using merge cells at all as they merely complicate things. In many cases you can get the format you want by using Center Across Selection -- Kevin Backmann "Ann" wrote: HELP - I'm formatting an Excel spreadsheet. I have some merged cells that have text in it that I want to wrap. I've selected wrap text on the fomatting menu....and the text does wrap, but the cell doesn't expand to show the wrapped text? I've tried selecting the row and formatting it to "auto fit", but that doesn't work either. How do I get the cell to expand to show that wrapped text? I'm open to just about anything at this point. Any help is appreciated. Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapping text in merged cells
You have run into one of the "features" of merged cells.
Text will wrap but the rows will not autofit without using event code or a macro. If interested in event code see this................... http://groups.google.com/group/micro...1c160cbeb27874 Gord Dibben MS Excel MVP On Thu, 3 Apr 2008 07:18:00 -0700, Ann <Ann @discussions.microsoft.com wrote: HELP - I'm formatting an Excel spreadsheet. I have some merged cells that have text in it that I want to wrap. I've selected wrap text on the fomatting menu....and the text does wrap, but the cell doesn't expand to show the wrapped text? I've tried selecting the row and formatting it to "auto fit", but that doesn't work either. How do I get the cell to expand to show that wrapped text? I'm open to just about anything at this point. Any help is appreciated. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text wrapping in cells | Excel Discussion (Misc queries) | |||
Wrapping Text in a Merged Cell | Excel Discussion (Misc queries) | |||
mergeing cells and wrapping text | Excel Discussion (Misc queries) | |||
Wrapping text in merged cells | Excel Discussion (Misc queries) | |||
How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) |