text continuing in next row in a merge cell

[Guest]

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

 

[Guest]

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

 

[Guest]

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!

 

[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?threadm=e1$1uzL1BHA.1784@tkmsftngp05

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

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!

Gord Dibben MS Excel MVP

 

[Guest]

Thanks a lot!

Pey

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?threadm=e1$1uzL1BHA.1784@tkmsftngp05

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




Gord Dibben MS Excel MVP