 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007row autofit
I am running excel 2003. If I set a row to auto fit. and I set the cells to wrap text. If I start typing text, it will wrap in the cells. growing the row height as needed. Now, If I merge some cells. It will no longer grow the height to wrap text. how come? is there a way to merge cells and have the text wrap? thanks Merged cells won't autofit -- even if you try to manually autofit the row. Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like: http://groups.google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05 If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm > I am running excel 2003. > If I set a row to auto fit. and I set the cells to wrap text. [quoted text clipped - 7 lines] > is there a way to merge cells and have the text wrap? > thanks  SignatureDave Peterson thanks for the help Do you know if it is fixed in 2007? > Merged cells won't autofit -- even if you try to manually autofit the row. > [quoted text clipped - 15 lines] > > is there a way to merge cells and have the text wrap? > > thanks No, I don't. > thanks for the help > Do you know if it is fixed in 2007? [quoted text clipped - 24 lines] > > > > Dave Peterson SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.