Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sawyet5
 
Posts: n/a
Default 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   Report Post  
Ron Coderre
 
Posts: n/a
Default 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   Report Post  
Duke Carey
 
Posts: n/a
Default 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   Report Post  
Chip Pearson
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Help Off line Shrikant Excel Discussion (Misc queries) 0 August 31st 05 10:27 AM
Is there a command line "switch" To close Excel Randy Wayne Excel Discussion (Misc queries) 2 August 22nd 05 09:58 PM
How can I get excell to ignore line breaks? LindaC Excel Discussion (Misc queries) 3 June 14th 05 08:20 AM
manual line breaks cwee Excel Discussion (Misc queries) 2 April 21st 05 05:48 PM
Adding line breaks by using find and replace soozie Excel Discussion (Misc queries) 3 March 7th 05 12:04 AM


All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"