More Lines of Text

Since this is a blog for Advanced Excel Users, I sometimes hesitate writing about a technique that is quite simple. What I have found over the years, however, is that some Simple techniques have been overlooked by some truly accomplished Excel practitioners.

Although the focus of Excel is numbers, there are times when you need to enter text into cells as well. Sometimes you may even want to add another paragraph (or perhaps just a line break) in a single cell. If you are working in Word, that’s easy – just hit the Enter key.

In Excel, however, hitting Enter will just take you to the next row below. “Well, of Course, You Say!” But what if you want to Add More Lines of Text within the selected cell? The solution is so easy it will make you laugh.

All you need to do is press Alt+Enter to start a new line in the cell in which you are typing or editing. That’s all there is to it! (See if you colleagues know that one…). Cheers.