how can i create multiple rows in one row in excel?

Question

lol... idk if i worded this right, but i want to create three rows in ONE row... is there anyway to do that?

Answer 1

No, there is no way in excel to do that. But I get the feeling that is not what you actually want to do. There IS a way to do whatever it is you really want. What do you need 3 rows in 1 for?

Answer 2

I don't think you worded that well.



What are you trying to do? If you create three rows, then the result won't be a single row, it will be three. Are you trying to create three rows of text in one cell? You can do that by manipulating text size and (in format cells) text control - wrap text.

Answer 3

From your question It seems is not possible.

But to have three in one, do the following steps:-

Shadowed the first three cells A1,A2 and A3, then Merge Cells. the result will be three rows in one.

Answer 4

hold the alt button and press return