Microsoft KB Archive/154673

= ALT+ENTER Fails to Insert Hard Carriage Return After Pasting =

Article ID: 154673

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q154673





SYMPTOMS
When you click the formula bar and press ALT+ENTER under Windows, or CTRL+OPTION+RETURN on the Macintosh, Microsoft Excel fails to insert a hard carriage return.



CAUSE
This problem may occur when you do the following:
 * You copy text in a cell, click the formula bar, copy a portion of the text in the cell, paste the text in the formula bar, and then press ALT+ENTER under Windows, or CTRL+OPTION+RETURN on the Macintosh. -or-


 * You copy text that contains a hard carriage return, paste the text to another cell, click the formula bar, and then press ALT+ENTER under Windows, or CTRL+OPTION+RETURN on the Macintosh.

NOTE: If you then click an empty cell and press ALT+ENTER under Windows, or CTRL+OPTION+RETURN on the Macintosh, Microsoft Excel may paste the text that you copied earlier instead of inserting a hard carriage return.



WORKAROUND
To work around this problem, quit and restart Microsoft Excel.

You can also try using in-cell editing instead of editing in the formula bar.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
The ALT+ENTER keystroke is used to insert a hard carriage return in a cell in order to continue typing text on a second line in that cell.

