How can i write in two lines in same cell in MS Excel?

Question

If i enter text more than the size of a cell, it will exceed and i need to resize the cell.
But i saw somewhere, where they wrote the data in multiple lines.
Do you know how to do it?
Hope you got my question.
In a cell i wanna enter :

i am entering this data
and this data in same cell
but in multiple lines


****
Not in three different cells
****
Anybody have answer for this?
Thanks

Answer 1

Highlight that cell.
Go to FORMAT menu -> CELLS
ALIGNMENT tab.
Select WRAP TEXT.

Or after a word type ALT + ENTER.

Answer 2

Multiple Lines In Excel Cell

Answer 3

I could keep data with line breaks in a single cell in Excel by pasting the data in the formula bar . The line breaks happlily come into the same cell and you have a multiline text in one cell.
Also pressing ALT+Enter in a cell inserts a line break inside the cell .

Answer 4

Right click on the cell, click on format cells, select the alignment tab and click wrap text option then click ok.

Answer 5

i don't remember exactly what tab, might be Edit, that you look for Text wrap, it will automatically go to the other line, within the same cell.

Answer 6

Say you have above data in A1:B2. Try this formula. =INDEX($A$1:$B$2,IF (MOD(ROW(A1),2)=0,2,MOD (ROW(A1),2)),INT((ROW(A1)-1)/2)+1) Depending on how many rows & columns you have, you might have to change the formula a little. Add details if you need more info.