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, butyou 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 toa new line. This works both when you're entering in the formula bar or directly in a cell. Created Date: 05/08/2002 Last Reviewed: 05/08/2002 Rev. Date: