Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to auto fit merged cells with wrapped text
(auto fit the row of merged columns). However, this does not work. It isn't just the macro either, I can't do this just in excel, which I never realized. Does anyone know if there is any way around this? Let me know. Thanks! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
AFAIK no way around this as this is one of the problems with merged cell (therefore nearly all would recommend NOT to use merged cell at all!) -- Regards Frank Kabel Frankfurt, Germany Wandering Mage wrote: I am trying to auto fit merged cells with wrapped text (auto fit the row of merged columns). However, this does not work. It isn't just the macro either, I can't do this just in excel, which I never realized. Does anyone know if there is any way around this? Let me know. Thanks! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Wandering Mage,
Jim Rech posted the following a routine to handle this: http://tinyurl.com/4c5l6 ___ Regards, Norman "Wandering Mage" wrote in message ... I am trying to auto fit merged cells with wrapped text (auto fit the row of merged columns). However, this does not work. It isn't just the macro either, I can't do this just in excel, which I never realized. Does anyone know if there is any way around this? Let me know. Thanks! |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello "Wandering Mage"
Must you use Merged Cells? I dislike this feature in MS-Excel and try to avoide it by all means. Sorry this might not solve your problem, butI think having multiple opinions may help. Wassim "Wandering Mage" wrote in message ... I am trying to auto fit merged cells with wrapped text (auto fit the row of merged columns). However, this does not work. It isn't just the macro either, I can't do this just in excel, which I never realized. Does anyone know if there is any way around this? Let me know. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrap text in merged cells VBA | Excel Discussion (Misc queries) | |||
Wrap text in merged cells | Excel Worksheet Functions | |||
word wrap in non-merged cells | Excel Discussion (Misc queries) | |||
Auto adjusting merged cells with wrap text on | Excel Discussion (Misc queries) | |||
Can word wrap and merged cells auto row height properly in Excel | Excel Discussion (Misc queries) |