How to create a line break in a cell in Excel

I use line breaks all the time in Word documents often without thinking. I didn’t know that you could create a line break within a cell in Excel. If you press return in Excel, it takes you to the next cell.

Create a line break in a cell in Excel

To reduce the width of a column heading because the title of the column is a lot wider than the data below, here’s how to split the cell into multiple lines:

1. Select the cell where you want additional lines
2. Type the first line
3. Press ALT+ENTER for Windows and CTRL+OPTION+ENTER for Mac
4. Type the second line
5. Repeat step 3 if you have additional lines

Such a handy tip to know!