Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Word Wrap, again

Posted by Rob on May 09, 2001 10:24 PM

its me again,
thanks for the reply to my question of message 16824, but i know you can merge cells, but the point is i dont want them merged...i was trying to see if there is a way to word wrap without merging the different cells... can anyone else help?
thanks.

Re: Word Wrap, again

Posted by Dave Hawley on May 10, 2001 4:48 AM

Hi Rob

Select the cell with the entry and also any sorrounding cells you want included. Go to Format>Cells>Alignment and choose "Centre across select" then "Justify"

Dave

OzGrid Business Applications

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.