How To Return In Excel Cell?

Press Alt + Enter to insert a line break within the same cell

Enable Wrap Text if the text does not display on multiple lines

Use CHAR(10) in a formula to return a line break in a cell

On Mac, press Control + Option + Return or Command + Option + Return, depending on Excel version

In formulas, concatenate text with CHAR(10) to place content on separate lines

Make sure the cell is formatted to show wrapped text if needed

Suggested for You

Trending Today