Business Tools Blog

Have you ever wanted to create multiple rows or line breaks in a single cell in Excel?

This is one of the lesser known excel tips, but it is very simple.

First, select Wrap text for the cell(s)

1. Select format, then cells
2. Select Wrap text
3. Click OK

Second, type the phrase that you want to show up in the cell:

Third, separate into 3 rows, by clicking ALT+Enter where you want the page breaks to appear.  In the example below, I clicked ALT+Enter after “Revenue”, and after “NetEx”

And voila – you have 3 rows.