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.

The detailed instructions to start a new line in a cell are provided: 3 ways to insert a line break in Excel.

5 steps to insert multiple lines into a cell

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.

121 comments

  1. Thanks so much, I couldn't get the CHAR(10) version of it working as I was missing "" for the text strong or else the = sign, but got it working afterwards.

    I had to do CHAR(10) and also had to word wrap the cells too: select all cells(the little arrow between the A and 1 top left of the screen) and choose the Home | "Wrap Text" for ALL cells

    I'm using Excel 2007 on Windows 11

    Exact Cell formula:

    =E10&" "&F10&CHAR(10)&I10&CHAR(10)&H10&CHAR(10)&"Ireland"

    Which Gives:

    Forename Surname
    Address
    Postcode
    Country

    Thanks again, hope this helps someone else in the same situation

  2. Hello,

    I am attempting to get rid of line breaks in a document so they are stacked on top of each other in the same cell like so:

    red
    blue
    green
    black

    and not

    red,blue,green,black

    I can not figure out a formula or find and replace to do this to the many sheets i have assigned to me. ANY help is appreciated as this has just been given to me and is due tomorrow. Thank you.

  3. Can each line include a formula?
    =L2&" | "&K2&" Stars"&" "
    &G2&": "&H2

      • When I type 2 formulas in both lines of a cell, it shows "FALSE" as output

  4. thank you for your help it's very useful

  5. I cant believe with all the power that excel has that it impossible to set a cell to start a new line just by pressing enter without having to go through the Alt ect process. I am putting together a spread sheet for techs to complete and as they type the info into the cell each bit of info should be on a separate line in the same cell, they would just hit enter.
    There must be a way that a cell can accept enter as an add a new line without all the issues of alt key etc
    much the same way this dialogue box works.

    Any help always appreciated.

  6. Alt Enter seems to work for up to 3 lines in a cell. After that I get #############################

  7. Thanks a lot Mr. ALEX.

  8. Hey Alex! How do I make it so that there are multiple rows in one cell? Do you know what I mean?

    • Hi!
      Have you tried the ways described in this blog post? If they don’t work for you, then please describe your task in detail.

  9. thank u

  10. Thank you very much,

    I was struggling a lot with that :)

  11. thank you sir

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

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

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

  15. Thanks

  16. 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? :)

    • Highlight the column then format the cells to that currency

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

  18. Thank you ! :)

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

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