Line breaks in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me a way to insert line breaks within a single cell of an
Excel worksheet? I know how to wrap the text, but this doesn't allow you to
break the line of text in particular places.
 
When typing a cell entry:
Hold down the [Alt] key when you press [Enter].

That will insert a 'hard carriage return' in the cell

Does that help?

••••••••••
Regards,
Ron
 
If you are typing in the cell, use ALT+ENTER to enter a line
break. In a formula, use CHAR(10), e.g.,

="Line One"&CHAR(10)&"Line Two"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top