How to Get Multiple Lines in an Excel Cell Using Wrap Text

It is common to want to have more than one line in a cell in an Excel worksheet. To have multiple lines in a cell can be done using Word Wrap which is a formatting option. You can do this in format cells.

I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

[meredithroberson]

Thank you so much! Brilliant and straight to the point!!

[dm]

Do you know of a way to have two or more lines with bullet points in one cell? I’m using Excel 2019.

[satheeshbabu]

Sir how to reduce the space between two lines in single cell?

[robertchaffee]

How do you get multiple rows of numbers (not text) in a cell? Suppose I wanted 2 rows of numbers and each set of numbers was 6 digits.

[ofthirteen]

I come check here, to know how to wrap text then split cell to next column

[marceloribeirosimoes]

Now copy the text and paste to a text editor.
All those "paragraph" ideas will be lost.