Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
elmo2
 
Posts: n/a
Default Auto fit wrapped and merged cells

Using Excel 2003 if you have a number of cells that are merged and wrapped
how can you get the rows to auto fit height - I am sure this used to work on
previous versions of excel but does not seem to now (similarly for columns).
Is there a fix for this or an option I need to select or deselect?
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Elmo,

See this macro from Jim Rech:


http://tinyurl.com/4c5l6


---
Regards,
Norman



"elmo2" wrote in message
...
Using Excel 2003 if you have a number of cells that are merged and wrapped
how can you get the rows to auto fit height - I am sure this used to work
on
previous versions of excel but does not seem to now (similarly for
columns).
Is there a fix for this or an option I need to select or deselect?



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
How can I display and print all the data in a wrapped merged cell. lflinders Excel Discussion (Misc queries) 1 January 6th 05 03:05 AM
Wrapped text appears as xxxxxx RegV Excel Discussion (Misc queries) 0 December 15th 04 04:43 PM


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

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

About Us

"It's about Microsoft Excel"