ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I format cells in excel to allow me to hit return key ? (https://www.excelbanter.com/new-users-excel/34443-how-do-i-format-cells-excel-allow-me-hit-return-key.html)

excel novice

How do I format cells in excel to allow me to hit return key ?
 
I am trying to type several lines of text into a cell on a worksheet and when
I come to the end of the first sentence, and hit return, it automatically
places the curser in the next cell instead of going to the next line in the
same cell. Please help!

Ron Coderre

To put a "hard carriage return" in a string of text
Hold down the [alt] key when you press [Enter]

Does that help?

--
Regards,
Ron


"excel novice" wrote:

I am trying to type several lines of text into a cell on a worksheet and when
I come to the end of the first sentence, and hit return, it automatically
places the curser in the next cell instead of going to the next line in the
same cell. Please help!



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

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