Wrapping Text in Merged Cells (from Word into Excel)

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel wrapping incorrectly 1
Merged cells stop wrapping 4
Fixing text wrap in merged cells 1
XL2003: why does word wrap stop wrapping? 4
Wrapping Text in Merged Cells 4
"Diagonal" cells - text-wrapping question 0
Wrap text in merged cells 2
Wrapping text in a merged cell 3

Top