Wrapping Text in Merged Cells (from Word into Excel)

  • Thread starter Thread starter Bryon Glass
  • Start date Start date
B

Bryon Glass

When I attempt to copy and paste information from Word into Excel (merged cells), the information gets cut-off on the right side and seems to stop wrapping after a certain point. I inserted the macro to allow for the "vertical sizing". The problem I am having is getting the information to wrap correctly. I have selected the "wrap text" box. I can't seem to find a solution. Any help you can provide would be appreciated. Is there a way to increase the amount of information for a given cell as well (maybe that's what I'm missing since it seems to stop wrapping after a certain point)?

EggHeadCafe - Software Developer Portal of Choice
Installing Visual Studio .NET Beta 2: The Oddysey
http://www.eggheadcafe.com/tutorial...94-2d12d69bb89e/installing-visual-studio.aspx
 
If you add alt-enters (to force new lines within the cell) every 80-100
characters, then you should be able to see lots more.

But autofitting the rowheight doesn't work nicely with merged cells. You may
find that you have to manually adjust it.
 
Back
Top