Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I press enter inside a cell?

What I mean is, how do I go to the next line inside of a cell? When I press
enter it takes me tot he next cell, not the next line. Thanks!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How do I press enter inside a cell?

  1. Click on the cell where you want to enter text.
  2. Type the text that you want to enter.
  3. When you want to go to the next line, press the "Alt" key and "Enter" key at the same time. This will create a line break inside the cell.
  4. Type the text that you want to enter on the next line.
  5. Repeat steps 3 and 4 as needed to add additional lines of text inside the cell.

    Alternatively, you can also use the "Wrap Text" feature to automatically wrap text within a cell. Here's how:

    1. Click on the cell where you want to enter text.
    2. Type the text that you want to enter.
    3. Click on the "Wrap Text" button in the "Alignment" group on the "Home" tab. This will automatically wrap the text within the cell and create line breaks as needed.
    4. Type the text that you want to enter on the next line.
    5. Repeat step 4 as needed to add additional lines of text inside the cell.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default How do I press enter inside a cell?

Alt + Enter

--


Regards,


Peo Sjoblom


"subway" wrote in message
...
What I mean is, how do I go to the next line inside of a cell? When I
press
enter it takes me tot he next cell, not the next line. Thanks!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default How do I press enter inside a cell?

ALT+Enter

You see the effect after you leave the cell

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"subway" wrote in message ...
| What I mean is, how do I go to the next line inside of a cell? When I press
| enter it takes me tot he next cell, not the next line. Thanks!


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default How do I press enter inside a cell?

Hold down the ALT key and press Enter.

Hope this helps,

Pete

On Nov 30, 4:11 pm, subway wrote:
What I mean is, how do I go to the next line inside of a cell? When I press
enter it takes me tot he next cell, not the next line. Thanks!


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
I type a date (1/05) in a cell, press enter, it reads ####.Why? KIWI New Users to Excel 2 February 5th 07 04:14 PM
macros doesn't execute unless i go into cell and press enter. Emma Excel Discussion (Misc queries) 2 October 20th 06 05:12 PM
Cannot view cell content until I press enter AnisKhan Excel Discussion (Misc queries) 4 June 9th 06 06:06 PM
When I Press the Enter Key Nothing happens. bigev Excel Discussion (Misc queries) 1 March 1st 06 04:05 PM
must press enter 2x to move cell focus Lynn Excel Discussion (Misc queries) 0 March 18th 05 07:05 PM


All times are GMT +1. The time now is 12:06 AM.

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"