If you add an Alt + Enter to create a linefeed in the cell, the center across
and wrap text will work together.

i.e. this is a long line of text <Alt + Enter this is another line of text
<Alt + Enter<Enter


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 02:16:01 -0700, A wrote:

Under format cells/alignment, I have seen the option to horizontally align
text to "Centre across Selection" (the text is also wrapped across this
selection). Is there any way to wrap text and align to the left across
selection.

Thanks