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.
 

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

Wrap Text in Merged Cell - How? 8
XL2003: why does word wrap stop wrapping? 4
Excel wrapping incorrectly 1
wrap text in merge cells 7
How to Wrap Text 2
Word Wrap in Cell Stops??? 3
Word wrap in excel? 2
Wrap text in merged cells 2

Back
Top