ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text Format Within a Cell (https://www.excelbanter.com/excel-discussion-misc-queries/40860-text-format-within-cell.html)

cpmatthys

Text Format Within a Cell
 

How do you use a carriage return within a cell? I would like to start a
new line within a cell. As you know, when you hit the enter key, excel
will drop you down to the next cell.


--
cpmatthys
------------------------------------------------------------------------
cpmatthys's Profile: http://www.excelforum.com/member.php...o&userid=26379
View this thread: http://www.excelforum.com/showthread...hreadid=396552


Paul Sheppard


cpmatthys Wrote:
How do you use a carriage return within a cell? I would like to start a
new line within a cell. As you know, when you hit the enter key, excel
will drop you down to the next cell.


Hold down the Alt key and then use carriage return

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=396552


Norman Jones

Hi CP,

Try Alt -Enter


---
Regards,
Norman



"cpmatthys" wrote
in message ...

How do you use a carriage return within a cell? I would like to start a
new line within a cell. As you know, when you hit the enter key, excel
will drop you down to the next cell.


--
cpmatthys
------------------------------------------------------------------------
cpmatthys's Profile:
http://www.excelforum.com/member.php...o&userid=26379
View this thread: http://www.excelforum.com/showthread...hreadid=396552





All times are GMT +1. The time now is 01:52 PM.

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