MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Wrapping text in merged cells

Posted by Gail on January 10, 2002 6:42 AM

I need to be able to wrap text in a merged cell and then have everything show when I print the page.

Posted by Michael on January 10, 2002 7:01 AM

Make sure the cells are merged, make sure that the wrap text is selected and then make sure that the cell's size allows all of the information to be seen. If not you need to adjust either the column width or the row height to allow the full text of the cell to be shown.

Posted by Raoul on January 10, 2002 8:20 AM

I find that double clicking on the row height does not auto-fit the text when it is wrapping - anyone know how to make this work?


Posted by Gail on January 10, 2002 9:06 AM

Apparently this is not a feature allowed in Excel. I don't want to have to manually change the row size so it looks like I ned a macro or workaround.

Posted by Chris D on January 10, 2002 11:41 AM

The "Justify" button in the formatting commands toolbar will do it with just a single click........ not precisely what you asked, but it works with the same result