text continuing in next row in a merge cell

[Peyline]

Hi,

I have merge four cells, so my layout look better in other places in a table.
I need a help, the information what I write doesn't show, because it goes
under a next cell. I have tried select a "text continue (or something in
english)" in cell's setup, but it doesn't help.

What I must do so my text continued in next row in the cell (cell's altitude
grow)?

Thanks, Pey

[bj]

Try <format><cell><alignment><wrap text>

"Peyline" wrote:

> Hi,
>
> I have merge four cells, so my layout look better in other places in a table.
> I need a help, the information what I write doesn't show, because it goes
> under a next cell. I have tried select a "text continue (or something in
> english)" in cell's setup, but it doesn't help.
>
> What I must do so my text continued in next row in the cell (cell's altitude
> grow)?
>
> Thanks, Pey

[Peyline]

Hi, thanks for your time, but..

That's doesn't work, because I have "merged theses cells".
It work if I select only one cell (not merged).

ofcourse in cell, there are all information what I typed, but It goes under
the lower cell.

Does anybody know more advice?

Thanks!

"bj" wrote:

> Try <format><cell><alignment><wrap text>
>
> "Peyline" wrote:
>
> > Hi,
> >
> > I have merge four cells, so my layout look better in other places in a table.
> > I need a help, the information what I write doesn't show, because it goes
> > under a next cell. I have tried select a "text continue (or something in
> > english)" in cell's setup, but it doesn't help.
> >
> > What I must do so my text continued in next row in the cell (cell's altitude
> > grow)?
> >
> > Thanks, Pey

[Gord Dibben]

Best if you stick to the same thread.

Wrap text works fine with merged cell.

What doesn't work is the Row Autofit.

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

http://groups.google.com/groups?thre...%40tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm

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


Gord Dibben Excel MVP


On Fri, 7 Jul 2006 07:56:02 -0700, Peyline <[email protected]>
wrote:

>Hi, thanks for your time, but..
>
>That's doesn't work, because I have "merged theses cells".
>It work if I select only one cell (not merged).
>
>ofcourse in cell, there are all information what I typed, but It goes under
>the lower cell.
>
>Does anybody know more advice?
>
>Thanks!
>
>"bj" wrote:
>
>> Try <format><cell><alignment><wrap text>
>>
>> "Peyline" wrote:
>>
>> > Hi,
>> >
>> > I have merge four cells, so my layout look better in other places in a table.
>> > I need a help, the information what I write doesn't show, because it goes
>> > under a next cell. I have tried select a "text continue (or something in
>> > english)" in cell's setup, but it doesn't help.
>> >
>> > What I must do so my text continued in next row in the cell (cell's altitude
>> > grow)?
>> >
>> > Thanks, Pey

Gord Dibben MS Excel MVP

[Peyline]

Thanks a lot!

Pey

"Gord Dibben" wrote:

> Best if you stick to the same thread.
>
> Wrap text works fine with merged cell.
>
> What doesn't work is the Row Autofit.
>
> You can resize manually or via Macro. Jim Rech has written
> code for this.
>
> http://groups.google.com/groups?thre...%40tkmsftngp05
>
> Also revised code for special cases.
>
> http://snipurl.com/dfsm
>
> The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
> copying, pasting, sorting, filtering and autofitting.
>
>
> Gord Dibben Excel MVP
>
>
> On Fri, 7 Jul 2006 07:56:02 -0700, Peyline <[email protected]>
> wrote:
>
> >Hi, thanks for your time, but..
> >
> >That's doesn't work, because I have "merged theses cells".
> >It work if I select only one cell (not merged).
> >
> >ofcourse in cell, there are all information what I typed, but It goes under
> >the lower cell.
> >
> >Does anybody know more advice?
> >
> >Thanks!
> >
> >"bj" wrote:
> >
> >> Try <format><cell><alignment><wrap text>
> >>
> >> "Peyline" wrote:
> >>
> >> > Hi,
> >> >
> >> > I have merge four cells, so my layout look better in other places in a table.
> >> > I need a help, the information what I write doesn't show, because it goes
> >> > under a next cell. I have tried select a "text continue (or something in
> >> > english)" in cell's setup, but it doesn't help.
> >> >
> >> > What I must do so my text continued in next row in the cell (cell's altitude
> >> > grow)?
> >> >
> >> > Thanks, Pey
>
> Gord Dibben MS Excel MVP
>