How to add rows within a cell?

[Bellaggio1770]

Hi,

I have an Excel document with stretched cells (they were pulled to make them larger than the original cells).

I would like to add cells within these enlarged cells. (subdividing a cell into several smaller cells). Is that possible?

Thank you

[mehmetcik]

That is not possible.

You could merge the adjacent cells to give you the same effect BUT

Merging Cells causes so many issues that you should avoid doing that.

However you can set the cell to wrap text, so you will have many lines

You can also insert carriage returns into your cell


Wrap text must be enabled.

Please Login or Register  to view this content.

[MrShorty]

I would like to add cells within these enlarged cells. (subdividing a cell into several smaller cells). Is that possible?

No it is not possible. Considering that you already have about 1E6 x 16000 cells at your disposal, I'm not sure why you would want or feel a need to add more cells to the spreadsheet.

If your intention is to sum the entries inside of a single cell, then I would avoid "wrapping" text inside of a single cell for each entry. You will go to all that effort to combine all of your data into a single "text string", then you will have to go to additional effort in your summing function to separate the individual elements out of the text string for summation. IMO, it is easier to keep each individual datum in its own cell from the beginning and sum a range of cells.

If you need help figuring out how to structure the spreadsheet and/or the summation function, let us know exactly what you are trying to do, and we'll help you figure it out.

[newdoverman]

Is this an Excel worksheet that actually does calculations for you or is it just for organizing text? If the it is a functioning Excel doing calculations, what you want isn't possible. It can be simulated by merging cells but that is a disaster for calculating. If on the other hand it is just for the organization of text, use Word. Word tables can have the cells split several times vertically and horizontally.