Wrapping text on merged cells

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

As I was told once in the NGs:
----------------------------
Have you tried,
"Center Across Selection"?

This works as you wish, as long as you're combining columns and *not rows*.

First, select the cells you wish to combine, then:

<Format> <Cells> <Alignment> tab,
In the "Horizontal" box, click the down arrow and choose:
"Center Across Selection"
Then click on your
"Wrap Text"
Then <OK>

This will automatically adjust the height of the row and, as the command
states, center the entry across the number of columns selected.

Don't forget though, if you manually try to change or adjust the height of
the row, automatic height adjustment is turned *off*, and must be reset to
be returned to automatic, by either:
<Format> <Row> <AutoFit>
Or the keystrokes,
<Alt> O R A
----------------------------

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain
 
Hi,

I'm unable to wrap text (automatically adjusting row
height) for merged cells. Is there any that this can be
done? The only work-around that I've found has been to
manually adjust row height.

Thanks!
John
 
John

Merged cells will allow "wrap text" from Format>Cells>Alignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP
 
Back
Top