How to wrap text in a merged cell

  • Thread starter Thread starter kristi
  • Start date Start date
K

kristi

We are trying in a larged merged cell to wrap the text
with a left alignment. We have the cell set up now to
wrap text/merged cell, but it will not complete this. The
cell already contains insert problem and I would like this
to start the next line down. Thanks! Kristi
 
I had this same question a while ago and someone was nice enough to help me.
I actually pasted the text into a Notepad document. Here's the solution I
was given:

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
 
Oops

krista
Wrap text should work without any problems in a merged group of cells. However the rows won't autofit so you need to manually adjust the row height. In regard to your comment "start the next line down", you can use Alt-Enter to insert a carriage return inside a cell

Good Luck
Mark Graesse
(e-mail address removed)

----- kristi wrote: ----

We are trying in a larged merged cell to wrap the text
with a left alignment. We have the cell set up now to
wrap text/merged cell, but it will not complete this. The
cell already contains insert problem and I would like this
to start the next line down. Thanks! Krist
 
Back
Top