Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
How to add cells within a cell?
Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
Please explain
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jrps" wrote in message ... How to add cells within a cell? Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
Hi Bernard,
As in Word function, I want to divide an Excel cell into many cells so that add data without changing row. Thanks. "Bernard Liengme" wrote: Please explain -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jrps" wrote in message ... How to add cells within a cell? Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
Cells cannot be split; they can be merged (Merge & Center tool) horizontally
and vertically To get multiple lines of text (no border line in between) in one cell: type CAT, then ALT+ENTER, then DOG Hope this helps best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jrps" wrote in message ... Hi Bernard, As in Word function, I want to divide an Excel cell into many cells so that add data without changing row. Thanks. "Bernard Liengme" wrote: Please explain -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jrps" wrote in message ... How to add cells within a cell? Thanks in advance. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
A cell is defined as the intersection between a row and a column. [That's
where the cell references come from.] You can't insert extra cells without inserting extra rows and/or columns. -- David Biddulph "jrps" wrote in message ... Hi Bernard, As in Word function, I want to divide an Excel cell into many cells so that add data without changing row. Thanks. "Bernard Liengme" wrote: Please explain -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jrps" wrote in message ... How to add cells within a cell? Thanks in advance. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
As Word function I just want to split a cell into many cells so that I can
add data without changing the row. Is it possible in Excel 2003? Thank you. "David Biddulph" wrote: A cell is defined as the intersection between a row and a column. [That's where the cell references come from.] You can't insert extra cells without inserting extra rows and/or columns. -- David Biddulph "jrps" wrote in message ... Hi Bernard, As in Word function, I want to divide an Excel cell into many cells so that add data without changing row. Thanks. "Bernard Liengme" wrote: Please explain -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jrps" wrote in message ... How to add cells within a cell? Thanks in advance. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
On May 16, 8:11 am, jrps wrote:
As Word function I just want to split a cell into many cells so that I can add data without changing the row. Is it possible in Excel 2003? Thank you. As mentioned, you can't split/add cells without "changing the row". That's the same thing. If you have several items in one cell and want to split those to other cells, check out "Text To Columns" in the Data menu. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up many cells within a cell
Perhaps you didn't read what I said:
"A cell is defined as the intersection between a row and a column. [That's where the cell references come from.] You can't insert extra cells without inserting extra rows and/or columns." Was it clearer that time? You can add data without extra cells. Alt+Enter will give a line break within a cell, if that's what you want. -- David Biddulph "jrps" wrote in message ... As Word function I just want to split a cell into many cells so that I can add data without changing the row. Is it possible in Excel 2003? Thank you. "David Biddulph" wrote: A cell is defined as the intersection between a row and a column. [That's where the cell references come from.] You can't insert extra cells without inserting extra rows and/or columns. -- David Biddulph "jrps" wrote in message ... Hi Bernard, As in Word function, I want to divide an Excel cell into many cells so that add data without changing row. Thanks. "Bernard Liengme" wrote: Please explain -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jrps" wrote in message ... How to add cells within a cell? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cell contents from many cells and pasting into one cell | Excel Discussion (Misc queries) | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Sorting cells: a list behind the cells do not move with the cell | Excel Discussion (Misc queries) | |||
Cell data overruns into adjacent cell(cells). | Excel Discussion (Misc queries) | |||
Copy cells into range of cells until cell change | Excel Worksheet Functions |