How do I format cells in excel to allow me to hit return key ?

E

excel novice

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!
 
R

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Converting URLs in comments to Markdown-formatted links 2
Unwanted change to capital letter 1
Problem with MS Word paragraph and character styles: format getting messed up 2
In Excel how do I force text into next line before first is full? 8
How to "return" in a merged cell. 3
Alt Enter Creates Tab Character 2
Convert code to lookup three criteria return fourth 15

Top