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.Spreadsheet

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!



How to create a line break in a cell in Excel
Share this
Tagged on: