Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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!



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrap text in merged cells VBA dme82 Excel Discussion (Misc queries) 2 August 15th 08 09:08 AM
Wrap text in merged cells Lena_Office Excel Worksheet Functions 6 March 22nd 07 04:21 AM
word wrap in non-merged cells Arun Excel Discussion (Misc queries) 2 October 20th 06 05:55 AM
Auto adjusting merged cells with wrap text on Sony Excel Discussion (Misc queries) 1 August 24th 06 04:15 PM
Can word wrap and merged cells auto row height properly in Excel wchernock Excel Discussion (Misc queries) 1 May 30th 06 03:04 PM


All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"