Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 11th 05, 01:57 PM
[email protected]
 
Posts: n/a
Default How do you start a new line within a cell?

I think this is a very basic question, but how do you start a new line
(or break a line) within a cell?
When I try to hit enter, the hightlight just moves to the next cell.

Thank you.


  #2   Report Post  
Old August 11th 05, 02:14 PM
FSt1
 
Posts: n/a
Default

hi,
data in a cell is stored as a continuous string. there is no "new line" per
say.
but you can wrap the text.
formatcellsalignment tab check wrap text.
this way the text in the cell will seem to be on different lines.

regards
FSt1

" wrote:

I think this is a very basic question, but how do you start a new line
(or break a line) within a cell?
When I try to hit enter, the hightlight just moves to the next cell.

Thank you.


  #3   Report Post  
Old August 11th 05, 02:14 PM
Gary's Student
 
Posts: n/a
Default

Use ALT-ENTER rather than ENTER
--
Gary's Student


" wrote:

I think this is a very basic question, but how do you start a new line
(or break a line) within a cell?
When I try to hit enter, the hightlight just moves to the next cell.

Thank you.


  #4   Report Post  
Old August 12th 05, 11:37 AM
Bob Phillips
 
Posts: n/a
Default

Use Alt-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
I think this is a very basic question, but how do you start a new line
(or break a line) within a cell?
When I try to hit enter, the hightlight just moves to the next cell.

Thank you.



  #5   Report Post  
Old August 12th 05, 02:39 PM
Sumeet Chopra
 
Posts: n/a
Default


use alt and enter
or
either go to cell formatting and select work wrap


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
how do I enter more than one line in the same Excel Cell by using. vsimmons Excel Discussion (Misc queries) 12 January 3rd 09 01:04 AM
make line in chart start at y axis Tone Charts and Charting in Excel 1 May 5th 05 09:23 AM
How can I strip a new line /nl in a cell in Excel globally Joe Excel Worksheet Functions 1 February 10th 05 07:29 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 07:10 PM
Line styles for Cell Borders Carl Excel Discussion (Misc queries) 1 December 2nd 04 04:28 AM


All times are GMT +1. The time now is 01:44 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017