How do I add a new line inside an Excel cell?

Press Alt+Enter while typing in a cell to insert a line break. Wrap Text must be enabled for the break to display visibly. Double-click the cell first if it is already populated.

How do I add a line break inside an Excel formula?

Use CHAR(10) in your formula: =A1&CHAR(10)&B1 joins two values with a line break between them. Wrap Text must be on for the cell to display the break.

Can I remove all line breaks from an Excel cell using a formula?

Yes - use =SUBSTITUTE(A1, CHAR(10), ' ') to replace all line breaks with a space, or =SUBSTITUTE(A1, CHAR(10), '') to remove them entirely.

101Excel Hacks

Back to Blog

Excel featuresHack 30

carriage return

cell paragraph

How to Add Line Breaks and Paragraphs Inside an Excel Cell

Excel Hack #30

9 views

1 min read

2018-09-03

How to Add Line Breaks and Paragraphs Inside an Excel Cell

You can add a carriage line to your Excel cell by pressing Alt + Enter. This is helpful when you are trying to separate content in a cell into paragraphs.

You can add a carriage line to your Excel cell by pressing Alt + Enter.

This is helpful when you are trying to separate content in a cell into paragraphs.

How to Add Line Breaks and Paragraphs Inside an Excel Cell

Frequently Asked Questions

How do I add a new line inside an Excel cell?

How do I add a line break inside an Excel formula?

Can I remove all line breaks from an Excel cell using a formula?