Forcing new lines within worksheet cell entries in Excel (97/2000/2002)

Excel is capable of storing large amounts of text data in a cell, but you most likely don't find the information readable when it's in a long string. If you'd prefer that information within a cell be broken onto multiple lines, you can manually insert line breaks to do exactly that.

To do so, just press [Alt][Enter] and your insertion point moves down to a new line. This works both when you're entering in the formula bar or directly in a cell.