How To Make Two Lines in A Cell

[ad]Dear Computer Lady,

I am using Windows XP with Excel 2002.

I would like to know if there is a way to have 2 lines of type in each cell (for a round robin tournament spreadsheet I’m trying to create)?

Thanks, Geri

Dear Geri,

There is a way to create two (or more) lines of text in a single cell.

When you are typing in an excel cell, just hold down the “Alt” key on your keyboard and press the “enter” key.

This will keep you in the same cell, and create a second line in that cell.

You might need to adjust the line height and column width to get the text in the cell to display the way you want. Just point your cursor to the intersection of the rows and drag up or down.


It’s Your Turn: What do you think?
…. Share your experience in the comments box below.

Elizabeth Boston is a Web designer, Social Media Consultant and managing editor of, “Ask The Computer Lady”.
Connect with

Previous Post

Red Printing Calculator

Next Post

How To Create A Facebook Business Page


    • Rhino
    • March 7, 2014

    That’s amazing! I did not know that and I’ve been using Excel since ’94!!!!

    Works in 2010 version too… and can even go 3 or more lines. However, I did find that if I was adding a 3rd line (and 4th & 5th) that they somehow popped into the middle instead of being at the end. Then I saw in the address bar an arrow and clicking on it showed the other lines so I could now get the additions in the correct order. This Will Be Useful! Thank you Elizabeth.

Comments are closed.