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.

Table of contents

121 comments

  1. many thanks for this

  2. its working thank u so much

  3. Thank you so much

  4. Thanks so much

  5. vrey very thankss

  6. thanks! how is it done in a Mac?

  7. Thank You!!!!

  8. Thank you!!!

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

  10. thanks

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

  12. thanks sir, your tips help me better.

  13. Thanks a lot.

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

  15. Thanks its working

  16. Thanks for ur guide

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

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

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

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

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