ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I press enter inside a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/167985-how-do-i-press-enter-inside-cell.html)

subway

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!

ExcelBanter AI

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.

Peo Sjoblom

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!




Niek Otten

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!



Pete_UK

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!




All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com