ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   auto fit-wrap texted merged cells (https://www.excelbanter.com/excel-programming/305035-auto-fit-wrap-texted-merged-cells.html)

Wandering Mage

auto fit-wrap texted merged cells
 
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!

Frank Kabel

auto fit-wrap texted merged cells
 
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!



Norman Jones

auto fit-wrap texted merged cells
 
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!




Wassim

auto fit-wrap texted merged cells
 
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!



All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com