This is Office tips to Insert Break Line In Cell using different Office Spreadsheet software.

The tips explains the solution using Key Press and Formula.
For Key Press, Cell must be in edit mode before key press can be used.

This Office: Insert Break Line In Cell covers the following spreadsheet software:

• Microsoft Office Excel
• Corel Quattro Pro
• Apache OpenOffice/LibreOffice Calc
• SoftMaker PlanMaker
• KingSoft Spreadsheets

 

Microsoft Office Excel

Key Press:  Alt + Enter

Formula:

="Line 1" & CHAR(10) & "Line 2" & CHAR(10) & "Line 3"
=CONCATENATE("Line 1",CHAR(10),"Line 2",CHAR(10),"Line 3")

Notes:

• Cell must turn on “Wrap Text” to show break line in multi line
• When “Wrap Text” is turned off, Excel will show all in single line with break line display as “question mark inside a box”

• To turn on/off  “Wrap Text”:
  • right click on the Cell, select “Format Cells…”
  • navigate to “Alignment” tab.
  • Under “Text Control” -> “Wrap text”.
    Turn On  -> Checked
    Turn Off -> Unchecked

• Or “Wrap Text” can be turned on/off from Ribbon Menu
  • Microsoft Office 2007

 

 

 

Corel Quattro Pro

 

 

Key Press:  Alt + Enter

Formula:

+"Line 1"&@CHAR(10)&"Line 2"&@CHAR(10)&"Line 3"
@CONCATENATE("Line 1",@CHAR(10),"Line 2",@CHAR(10),"Line 3")

Notes:

• Cell must turn on “Wrap Text” to show break line in multi line
• When “Wrap Text” is turned off, Quattro will show all in single line with break line display as “a box”

• To turn on/off  “Wrap Text”:
  • right click on the Cell -> select “Selection Properties…” or Select on Cell -> Press “F12”
  • navigate to “Alignment” tab
  • Under “Cell Options” -> “Wrap text”.
    Turn On  -> Checked
    Turn Off -> Unchecked

Apache OpenOffice/LibreOffice Calc

Key Press:  Ctrl + Enter
Formula:

="Line 1" & CHAR(10) & "Line 2" & CHAR(10) & "Line 3"
=CONCATENATE("Line 1",CHAR(10),"Line 2",CHAR(10),"Line 3")

 

 

SoftMaker PlanMaker

 

Key Press:  Ctrl + Enter

Formula:

="Line 1"&CHAR(10)&"Line 2"&CHAR(10)&"Line 3"
=CONCATENATE("Line 1",CHAR(10),"Line 2",CHAR(10),"Line 3")

Notes:

• Cell must turn on “Wrap Text” to show break line in multi line
• When “Wrap Text” is turned off, PlanMaker will show all in single line with break line display as “a box”

• To turn on/off  “Wrap Text”:
  • Right click on the Cell -> select “Cell…” or Select Cell -> press “Ctrl+1”
  • Navigate to “Alignment” tab
  • Under “Properties” -> “Wrap text”.
    Turn On  -> Checked
    Turn Off -> Unchecked

• Or “Wrap Text” can be turned on/off from context menu (right click mouse on cell)

 

 

KingSoft Spreadsheets

 

Key Press:  Alt + Enter

Formula:

="Line 1"&CHAR(10)&"Line 2"&CHAR(10)&"Line 3"
=CONCATENATE("Line 1",CHAR(10),"Line 2",CHAR(10),"Line 3")

Notes:

• Cell must turn on “Wrap Text” to show break line in multi line
• When “Wrap Text” is turned off, Spreadsheets will show all in single line, break line character is not visible.

• To turn on/off  “Wrap Text”:
  • Right click on the Cell -> select “Format Cells…” or Select Cell -> press “Ctrl+1”
  • Navigate to “Alignment” tab
  • Under “Text Control” -> “Wrap text”.
    Turn On  -> Checked
    Turn Off -> Unchecked

• Or “Wrap Text” can be turned on/off from Ribbon Menu
  • KingSoft Spreadsheets 2013