Comments on: Enter multiple lines in a single Excel cell

Comments page 2. Total comments: 121

1. 

   pritam says:
   2021-05-20 at 4:40 am

   thank you sir

2. 

   Emmanuel says:
   2021-04-29 at 2:44 pm

   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"?

3. 

   Glen says:
   2021-04-16 at 3:40 pm

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

4. 

   David says:
   2021-03-31 at 7:17 am

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

5. 

   Anil Reddy says:
   2021-01-07 at 5:25 am

   Thanks

6. 

   SR says:
   2020-12-07 at 10:54 am

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

   I need this:

   £100.00
   £200.00
   £300.00

   But when I use Alt + Enter I get this:

   100
   200
   300

   Can anyone help please? :)

   1. 

      Blair says:
      2021-11-08 at 5:32 pm

      Highlight the column then format the cells to that currency

7. 

   Bandana says:
   2020-11-24 at 11:37 pm

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

8. 

   J says:
   2020-09-26 at 5:59 pm

   Thank you ! :)

9. 

   Emanuel Pietri says:
   2020-09-12 at 4:13 pm

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

10. 

    abusufian harun says:
    2020-08-27 at 5:16 am

    Thanks

11. 

    JH says:
    2020-08-10 at 7:53 pm

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

12. 

    raman murthy says:
    2020-07-31 at 5:42 am

    thank you.

13. 

    Vikas says:
    2020-06-21 at 5:01 pm

    Thank you!!

14. 

    Vaibhav Agarwal says:
    2020-06-09 at 2:45 am

    thanks..it worked..

15. 

    Neha Singh says:
    2020-04-22 at 11:01 am

    Thank you!

16. 

    David says:
    2020-02-23 at 10:20 am

    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

    1. 

       Jeffrey Pelham says:
       2021-12-09 at 3:15 pm

       Believe it or not, I had to use the OTHER Alt key on my keyboard. Not sure why this is. (I found this tip after a whole bunch of searching!)

    2. 

       Prince Tyagi says:
       2021-08-25 at 9:22 am

       Please increase that column/row size.

17. 

    RIG says:
    2020-01-22 at 10:25 am

    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!

18. 

    jyothi says:
    2019-08-20 at 1:10 pm

    Thank you

19. 

    Anonymous says:
    2019-03-13 at 7:25 pm

    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

20. 

    CJ says:
    2019-01-11 at 3:24 pm

    Thank you so very much.

21. 

    Patsy says:
    2018-11-21 at 8:21 pm

    Thanks SO much for the great and helpful info!

22. 

    MJ says:
    2018-05-01 at 12:00 pm

    Example :
    143
    550
    350
    440

23. 

    MJ says:
    2018-05-01 at 11:58 am

    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.

    1. 

       Doug says:
       2018-05-01 at 1:24 pm

       MJ:
       I don't believe you can SUM cells with line breaks without using VBA.
       A more complete discussion of this issue and a resolution can be found here:
       https://stackoverflow.com/questions/44828236/sum-numbers-in-one-cell-that-contains-line-break-excel
       The easiest resolution to this is to not enter line breaks or to remove the line breaks that may be in the cells.

24. 

    Doug says:
    2018-04-24 at 10:39 pm

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

25. 

    Bilisa says:
    2018-03-28 at 5:26 am

    Many Thanks

26. 

    Md.Nazrul islam says:
    2018-01-09 at 5:32 pm

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

    1. 

       TeachNow says:
       2022-11-10 at 3:56 pm

       Best answer for text already in cell. Thank you!

27. 

    Pat says:
    2017-12-28 at 6:50 am

    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?

    1. 

       Gennady Terekhov (Ablebits Team) says:
       2018-04-19 at 2:52 pm

       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.

       1. 

          Blair says:
          2021-11-08 at 5:36 pm

          AMAZING! Thank you so MUCH!!! Just saved me hours of work

28. 

    Farid Noori says:
    2017-11-06 at 1:32 am

    thanx alt plus enter also worked for me

29. 

    Joshua says:
    2017-10-23 at 11:16 am

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

    1. 

       Irina Pozniakova (Ablebits Team) says:
       2017-10-23 at 2:19 pm

       Hello Joshua,
       I'm afraid it is not possible to use different alignments within one cell. One possible workaround would be using different columns for values that you'd like to align differently.

30. 

    Sumanta says:
    2017-09-13 at 10:26 am

    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

    1. 

       Irina Pozniakova (Ablebits Team) says:
       2017-10-23 at 1:26 pm

       Hello Sumanta,
       If you are trying to remove line breaks in your cells, there are several ways you can go. Please see this blog post for detailed steps:
       https://www.ablebits.com/office-addins-blog/remove-carriage-returns-excel/

       If your task is different, please describe it in more detail.

31. 

    rojean says:
    2017-09-05 at 12:36 am

    many thanks for this

32. 

    poonam says:
    2017-08-10 at 10:13 am

    its working thank u so much

33. 

    Moustafa Halawany says:
    2017-07-19 at 3:35 pm

    Thank you so much

34. 

    Illa Sharma says:
    2017-06-22 at 11:27 am

    Thanks so much

35. 

    rajinsh sharma says:
    2017-04-29 at 8:09 am

    vrey very thankss

36. 

    jules says:
    2017-04-21 at 10:07 am

    thanks! how is it done in a Mac?

37. 

    Milind says:
    2017-03-07 at 12:39 pm

    Thank You!!!!

38. 

    Ashanta says:
    2017-03-02 at 6:20 pm

    Thank you!!!

39. 

    Krystin Kilman says:
    2017-01-12 at 6:12 pm

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

40. 

    jebin says:
    2016-12-29 at 11:29 am

    thanks

41. 

    Susarie Coetzee says:
    2016-11-15 at 12:27 pm

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

42. 

    pramoda sahoo says:
    2016-11-10 at 7:46 am

    thanks sir, your tips help me better.

43. 

    Mahidul Islam says:
    2016-10-20 at 11:09 am

    Thanks a lot.

44. 

    Nirthanakali says:
    2016-06-11 at 9:38 am

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

45. 

    Ashok Kumar Dubay says:
    2016-05-25 at 9:33 am

    Thanks its working

46. 

    Nathan says:
    2016-03-28 at 3:36 pm

    Thanks for ur guide

47. 

    Anonymous says:
    2015-11-11 at 4:26 pm

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

48. 

    KingBifoe says:
    2015-10-22 at 2:02 pm

    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

49. 

    Caprice Epps says:
    2015-09-18 at 8:23 pm

    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!

50. 

    Javeed says:
    2015-06-25 at 4:52 am

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