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:
- Select the cell where you want additional lines
- Type the first line
- Press ALT+ENTER for Windows and CTRL+OPTION+ENTER for Mac
- Type the second line
- Repeat step 3 if you have additional lines
Such a handy tip to know!