Enter multiple lines in a single Excel cell

When you have a lot of text in your Excel cells it can be a good idea to show it on more than one line. But how? Every time you enter text into a cell it longs to be on one line however long it is.
Here is how you can insert more than one line into one cell on your Excel worksheet.

Enter more than one line in a single Excel cell

5 steps to better looking data

Say you have a column with full names in your table and want to get the first and last ones on different lines. With these simple steps you can control exactly where the line breaks will be.

  1. Click on the cell where you need to enter multiple lines of text.
  2. Type the first line.
  3. Press Alt + Enter to add another line to the cell.
    Tip.Keep pressing Alt + Enter until the cursor is where you would like to type your next line of text.
  4. Type the next line of text you would like in the cell.
  5. Press Enter to finish up.

So just don't forget the Alt + Enter shortcut to get a line break at a specific point in a cell regardless of the cells width.

See also

Category: Excel Tips

Table of contents

80 responses to "Enter multiple lines in a single Excel cell"

  1. Abdullah Mian g says:


  2. pankaj says:

    Hey thanks Alexander, (Alt+Enter) worked for me.

  3. Padma says:

    Very thanks

  4. Padma says:

    many thanks

  5. LIZ says:


  6. Sh. Kamran Shafique says:

    Thanks, it make me easy to edit my worksheets

  7. seyfedin says:

    thank you!!!

  8. Kodak says:

    Thanks so much!

  9. Jenny says:

    Thanks a lot. it helped me to make my work easier.

  10. Raissa says:

    Very Helpful indeed

  11. HISHAM says:


  12. swara says:

    thanku buddy

  13. kknaidu says:

    Thank You alexandar

  14. Swami Kastur says:

    Its not working me.. Alt + Enter. Do anyone has any other suggestions?

  15. Aditya Johri says:

    Try using different ALT key.

  16. priya says:

    I have following data in one cell

    1980 : B.Com ; 1982 : MBA ; 1985 : P.hD

    I want to align data as given below :
    1980 : B.Com ;
    1982 : MBA ;
    1985 : P.hD

    I have huge list. I can not use alt entre for the entire list.
    Kindly help me suggesting different way of formatting

    • Hello Priya,

      You can select your records and use the standard Find and Replace feature in Excel: enter a semicolon and a space in the "Find what" field, switch to the Replace with field, enter a semicolon and press Ctrl+j on your keyboard, this shortcut stands for a line break. Then click "Replace All".

  17. azhar says:

    thanks my dear it working very good

  18. Bharat says:


    when I enter data using Alt+Enter, it does move to the next line but now all that I can see is #########. Please could you help me with that?

  19. Jagjeet says:

    Thanks for guiding me

  20. Nancy Arpitha says:


    Thank u so much to whoever published it as it helped me a lot.

  21. Javeed says:

    Hello, it was working in old version, can check in office 2013, Alt+Enter is not working.

  22. Caprice Epps says:

    Wow! So simple. It took 30 minutes and several complicated tutorial videos to find your simple way to enter several lines in one cell.
    Thank you!

  23. KingBifoe says:

    Please can this be applied in a data entry form? I would like to add more data under an entry in one particular cell. Thank you

  24. Anonymous says:

    oh! its a very needy information for me.. thanks!

  25. Nathan says:

    Thanks for ur guide

  26. Ashok Kumar Dubay says:

    Thanks its working

  27. Nirthanakali says:

    extemporaneously i tried i feel really too good........thank you

  28. Mahidul Islam says:

    Thanks a lot.

  29. pramoda sahoo says:

    thanks sir, your tips help me better.

  30. Susarie Coetzee says:

    Thank you very much for your advice and detailed instructions on this topic.

  31. Krystin Kilman says:

    i want to do this but still show currency. every time i use the alt+enter my currency disappears... any help? thank you!

  32. Ashanta says:

    Thank you!!!

  33. Milind says:

    Thank You!!!!

  34. jules says:

    thanks! how is it done in a Mac?

  35. rajinsh sharma says:

    vrey very thankss

  36. Illa Sharma says:

    Thanks so much

  37. Moustafa Halawany says:

    Thank you so much

  38. poonam says:

    its working thank u so much

  39. rojean says:

    many thanks for this

  40. Sumanta says:

    how to combine the multiple line of a single cell in excel
    Andra Pradesh #
    Emami #
    OPS AP 94 #
    Emami Ltd., 25-39/2, 7th Lane, R. R. Nagar, Kabela Industrial Area, Kabela, Vijayawada - 520012

  41. Joshua says:

    Thanks, alt + Enter worked for me, but how do i make the two different numbers sits at opposite ends?

  42. Farid Noori says:

    thanx alt plus enter also worked for me

  43. Pat says:

    I want to put text from 3 references into a single cell with multiple lines. I tried:
    =a1&(alt enter)
    b1&(alt enter)

    But this always comes out on the same line of the cell. Can I make it come out on 3 lines of the same cell?

    • Hello,

      If I understand your task correctly, please try the following formula:

      =A1 & CHAR(10) & B1 & CHAR(10) & C1

      When using line breaks to separate the concatenated values, you must have the “Wrap text” option enabled for the result to display correctly. To do this, press Ctrl + 1 to open the Format Cells dialog, switch to the Alignment tab and check the Wrap text box.

      Hope it will help you.

  44. Md.Nazrul islam says:

    at first type what ever you want then goto home manu and click on wrap-text icon

  45. Bilisa says:

    Many Thanks

  46. Doug says:

    Alt+Enter worked for me once, then not again, what I am now doing wrong.

  47. MJ says:

    I have entered number after using Alt+Enter in to one cell, now i need total of that cell, how I will get total pls help me.
    example. 143 550 350 440 all numbers are entered in to one cell using alt+enter now not able to get single cell total.

  48. MJ says:

    Example :

  49. Patsy says:

    Thanks SO much for the great and helpful info!

  50. CJ says:

    Thank you so very much.

  51. Anonymous says:

    for instance i have
    60% and i still want 30%,40%,70% to be below 60% as in 60% will cover all the other numbers
    pls how can i do it

  52. jyothi says:

    Thank you

  53. RIG says:

    Hello, I have a long text in a cell. This text needs to be in less than 4 line break. And each line can only have a maximum of 60 letter or characters. Thanks for your help!

  54. David says:

    When I press Alt+Enter and go to the next line, my text in the next line does not appear after pressing enter. Please help me out

  55. Neha Singh says:

    Thank you!

  56. Vaibhav Agarwal says:

    thanks..it worked..

  57. Vikas says:

    Thank you!!

  58. raman murthy says:

    thank you.

  59. JH says:

    Thank you! Never knew it was so simple. Clear and easy to follow

  60. abusufian harun says:


  61. Emanuel Pietri says:

    Thank you for tips!
    Just saved my wife's project :D

  62. J says:

    Thank you ! :)

  63. Bandana says:

    hey.....thank you so much. 'Alt + Enter' helps a lot

  64. SR says:

    How can I do this with currency? Alt + Enter gets rid of the currency.

    I need this:


    But when I use Alt + Enter I get this:


    Can anyone help please? :)

  65. Anil Reddy says:


  66. David says:

    Thanks! Your simple explanation to my query was just what I needed. BIg help!

  67. Glen says:

    Great, thanks, didn't know this after a long time using Excel, very helpful!

  68. Emmanuel says:

    Thanks buddy!
    What if i want to reverse the process... bringing the contents on the second line together with the contents on the first line to be on the same line "first line"?

  69. pritam says:

    thank you sir

  70. Erfan says:

    Thank you very much,

    I was struggling a lot with that :)

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)