Start new line in excel cell mac

When entering text into a cell, sometimes we’d like to insert a line break for better formatting. A line break is like when you’re in Word and you press Enter to create a new line.

This can also be called a carriage return. We’ll cover two ways to do this.

• Line breaks in plain text
• Line breaks in cell formulas

One thing is certain, you shouldn’t use two cells for creating the illusion of line breaks.

Adding a Line Break in Plain Text

This one is easy.

While you’re editing the text of a cell, you can simply press (or for Mac) to add a line break as shown below.

NOTE: This will automatically set Wrap Text ON for cell

Let’s take a look at what happens when you turn Wrap Text OFF:

Notice that in the formula bar the break is kept there, but it is one single line in cell .

New line in excel concatenate formula

This is because Excel needs to format the break and Wrap Text is the way to do it. The formula bar is immune to show any formatting, but it will show you the data you have (in this case, some text, then a line break and some more text after).

It’s just another

excel how to do line break in cell

excel how to enter line break in cell