Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text continuing in next row in a merge cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text continuing in next row in a merge cell
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
doesn't work
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
doesn't work
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 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
doesn't work
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Cell Capacity - text | Excel Discussion (Misc queries) | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions |