Comments on: 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 worksheet... Continue reading →

Comments page 4. Total comments: 121

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

  2. thanks sir, your tips help me better.

  3. Thanks a lot.

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

  5. Thanks its working

  6. Thanks for ur guide

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

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

  9. 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!

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

  11. Hello,

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

  12. Thanks for guiding me

  13. 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?

    1. colum width needs increasing or use wrap text

  14. thanks my dear it working very good

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

    1. 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".

  16. Try using different ALT key.

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

    1. Press Ctrl+Enter

    2. Do Space and wrap the cell

  18. Thank You alexandar

  19. thanku buddy

  20. THANKYOU SO MUCH

  21. Great!
    Very Helpful indeed

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

  23. Thanks so much!

  24. thank you!!!

  25. Thanks, it make me easy to edit my worksheets

  26. ALT + ENTER WORKED FOR ME

  27. many thanks

  28. Very thanks

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

  30. Thanks

    1. THANKS

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