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

61 Responses to "Enter multiple lines in a single Excel cell"

  1. Abdullah Mian g says:

    Thanks

  2. pankaj says:

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

  3. Padma says:

    Very thanks

  4. Padma says:

    many thanks

  5. LIZ says:

    ALT + ENTER WORKED FOR ME

  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:

    Great!
    Very Helpful indeed

  11. HISHAM says:

    THANKYOU SO MUCH

  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:

    Hi

    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:

    Hello,

    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)
    c1

    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.
    Thanks

  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 :
    143
    550
    350
    440

  49. Patsy says:

    Thanks SO much for the great and helpful info!

  50. CJ says:

    Thank you so very much.

  51. Anonymous says:

    help
    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

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard