In-cell carriage returns

Excel allows you to wrap text within a cell or within a merged set of cells. But it also allows you to force line-breaks within cells or merged cells.

If you want to create the equivalent of a carriage return within an Excel cell, hit ALT+Enter. The cursor will stay within the cell being edited, but will drop to the next line.

This can be useful when entering regular commentary in a single cell, such as weekly risk updates.

A word of caution though. Usually, these cells behave just fine. But occasionally, if you use the automatic cell height feature, it doesn’t respect these carriage returns and some of your cells’ contents may be hidden. There’s no solution to this beyond manually adjusting the row heights where you see this happening.

This entry was posted in Quick tips and tagged . Bookmark the permalink.

8 Responses to In-cell carriage returns

  1. Brian Hall says:

    So is there any way to remove the in-line cell carriage returns? How would I specify them in a search and replace function? They are messing up my Text to Columns! Thanks.

  2. Scott says:

    Above is not complete correct. alt+enter will add a "line return". Line return and carriage return are different. In above example it does have the same result of new line.


    [Alt][Enter] no good on my version. There is no discernible response on my screen.

Leave a Reply

Your email address will not be published. Required fields are marked *