Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Monica
 
Posts: n/a
Default How can I create a new line in a cell in Excel by hitting enter?

I need to just be able to hit enter in a cell and it create a new line in
that cell. Is there a way to do this so that I do not have to add more rows?
Please help!
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

Manual (forced) line break:

<Alt <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Monica" wrote in message
...
I need to just be able to hit enter in a cell and it create a new line in
that cell. Is there a way to do this so that I do not have to add more
rows?
Please help!


  #3   Report Post  
Carlos Antenna
 
Posts: n/a
Default

press <alt<enter where you want the line break

-- Carlos

"Monica" wrote in message
...
I need to just be able to hit enter in a cell and it create a new line in
that cell. Is there a way to do this so that I do not have to add more
rows?
Please help!



  #4   Report Post  
Monica
 
Posts: n/a
Default

But how do I get all the other rows to go down so that the cell does not just
go down into the next row? I want to be able to expand the cell down, but
for it to expand the entire row down so that it does not interfere with rows
below it...Is that possibe? Thanks!

"Carlos Antenna" wrote:

press <alt<enter where you want the line break

-- Carlos

"Monica" wrote in message
...
I need to just be able to hit enter in a cell and it create a new line in
that cell. Is there a way to do this so that I do not have to add more
rows?
Please help!




  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

The rowheight should expand to show the entire contents of that cell.

But if you've manually adjusted that row's height, excel won't change it
automatically.

You can either make the row wider manually -- or just autofit the row (and when
the row is "autofitted", then excel will expand and contract to what it needs).



Monica wrote:

But how do I get all the other rows to go down so that the cell does not just
go down into the next row? I want to be able to expand the cell down, but
for it to expand the entire row down so that it does not interfere with rows
below it...Is that possibe? Thanks!

"Carlos Antenna" wrote:

press <alt<enter where you want the line break

-- Carlos

"Monica" wrote in message
...
I need to just be able to hit enter in a cell and it create a new line in
that cell. Is there a way to do this so that I do not have to add more
rows?
Please help!





--

Dave Peterson
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 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to create a line chart with two X-axes in Excel JaVaughn Excel Discussion (Misc queries) 2 June 29th 05 04:52 PM
?? Extra blank lines in 'address' cell after exporting to Excel Hadyn Pkok Excel Discussion (Misc queries) 4 April 15th 05 11:34 PM
Copying excel format from cell to cell Loopy Darren Excel Discussion (Misc queries) 2 April 12th 05 04:29 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 08:10 PM


All times are GMT +1. The time now is 02:15 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"