text continuing in next row in a merge cell

P

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
 
P

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!
 
G

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!
Click to expand...

Gord Dibben MS Excel MVP
 
P

Peyline

Thanks a lot!

Pey

Gord Dibben said:
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
Click to expand...
 
Top