| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW?
i need to put two split rows inside of one cell
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW?
"blondie" wrote in message
... i need to put two split rows inside of one cell Alt+Enter will give you a new row within the cell. -- David Biddulph |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW?
i just tried that and it prints instead of splits
"David Biddulph" wrote: "blondie" wrote in message ... i need to put two split rows inside of one cell Alt+Enter will give you a new row within the cell. -- David Biddulph |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW?
You cannot "split" a cell into two pieces either horizontally or vertically.
Explain what you wish to achieve and perhaps someone can help. Gord Dibben MS Excel MVP On Mon, 9 Oct 2006 16:39:01 -0700, blondie wrote: i just tried that and it prints instead of splits "David Biddulph" wrote: "blondie" wrote in message ... i need to put two split rows inside of one cell Alt+Enter will give you a new row within the cell. -- David Biddulph |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW?
Assuming the data you want to split is in cell A!, you can insert a new row 2
and put your data into cels A1 and A2, then merge cels B1& B2, C1& C2, D1& D2 etc. It's more work, but you'll have the results you wanted. "blondie" wrote: i need to put two split rows inside of one cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Split cell without breaking word? | Excel Discussion (Misc queries) | |||
| Split cell help! | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
