Office: How to insert Break Line in Spreadsheet Cell

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

OFFICE_InsertBreakLineInCell_03

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”

OFFICE_InsertBreakLineInCell_05

  • 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

OFFICE_InsertBreakLineInCell_06

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

 OFFICE_InsertBreakLineInCell_07

 

 

Corel Quattro Pro

 

OFFICE_InsertBreakLineInCell_04

 

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”

OFFICE_InsertBreakLineInCell_08

  • 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

OFFICE_InsertBreakLineInCell_09

Apache OpenOffice/LibreOffice Calc

OFFICE_InsertBreakLineInCell_01

OFFICE_InsertBreakLineInCell_02

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

 

OFFICE_InsertBreakLineInCell_10

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”

OFFICE_InsertBreakLineInCell_08

  • 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

OFFICE_InsertBreakLineInCell_11

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

 OFFICE_InsertBreakLineInCell_12

 

KingSoft Spreadsheets

OFFICE_InsertBreakLineInCell_13

 

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.

OFFICE_InsertBreakLineInCell_14

  • 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

OFFICE_InsertBreakLineInCell_15

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

OFFICE_InsertBreakLineInCell_16

Updated: 05/10/2014 — 10:10 PM

Leave a Reply

Your email address will not be published. Required fields are marked *

16 − 15 =

YLNotes: Yunlong Notes © 2017 Frontier Theme