Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Line breaks in Excel?
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. |
#2
|
|||
|
|||
Line breaks in Excel?
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 "sawyet5" wrote: 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. |
#3
|
|||
|
|||
Line breaks in Excel?
Use Alt+Enter to break the text where you want to
"sawyet5" wrote: 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. |
#4
|
|||
|
|||
Line breaks in Excel?
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 "sawyet5" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Help Off line | Excel Discussion (Misc queries) | |||
Is there a command line "switch" To close Excel | Excel Discussion (Misc queries) | |||
How can I get excell to ignore line breaks? | Excel Discussion (Misc queries) | |||
manual line breaks | Excel Discussion (Misc queries) | |||
Adding line breaks by using find and replace | Excel Discussion (Misc queries) |