Skip to content Skip to main navigation Skip to footer

How to add second line in Excel cell

add second line in Excel cell

When you type a long sentence in a single cell in Excel, you might think about how to add second line in Excel cell. Maybe you are looking for a solution on how to put multiple lines in Excel cell. Every time you type any text in a cell it only shows in a single line though you increase the row height, no worries today I will show you how to add second line in Excel cell.

NOTE
Like Microsoft Word, ENTER do not work to add second line, In Microsoft Excel, ENTER means end cell editing.

Identify the problem

Add second line in Excel cell_1

Look at the image above. Cell width is too long than expected. if you increase the row height and reduce the column width still, it does not work. See the image below

Add second line in Excel cell_2

No worries, I will guide you on How to add second line in Excel cell.

Read More: How to sum up using Excel; SUM Function explained.

How to add second line in Excel cell

Say, you want to start a new line after Street, City, Zip code.

Place your cursor after Street Address in the cell and press Alt+Enter, a new line will start.

Add second line in Excel cell_

See what it looks like now.

Add second line in Excel cell_4

Another Way to add multiple lines in Excell

There is another way to add multiple lines in a cell.

  • Select the cell you want to add multiple lines, right-click and select Format Cells.

Add second line in Excel cell_5

  • Go to the Alignment tab, and click on the Wrap text check box under the Text control options.

Add second line in Excel cell_6

NOTE
Wrap text will adjust your text as per cell width and height. You will not have control over where you need to add a second line.

You can also use this tool with a single click also. Go to the Home menu> Wrap Text to change the overwriting text string to multiple lines.

Add second line in Excel cell_7

I hope, you are now able to add second line in Excel cell. If you have any more queries, please comment in the comment box. I will try to answer your question to the best of my knowledge.

0 Comments

There are no comments yet

Leave a comment

Your email address will not be published. Required fields are marked *