ExcelBanter - Can I put a carriage return in an EXCEL cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I put a carriage return in an EXCEL cell (https://www.excelbanter.com/excel-discussion-misc-queries/116224-can-i-put-carriage-return-excel-cell.html)

ulidech

Can I put a carriage return in an EXCEL cell

I want to put several lines in a cell without word wrapping if the column is
expanded. Can this be done?

Dave F

Can I put a carriage return in an EXCEL cell

ALT + Enter
--
Brevity is the soul of wit.

"ulidech" wrote:

I want to put several lines in a cell without word wrapping if the column is
expanded. Can this be done?

Gord Dibben

Can I put a carriage return in an EXCEL cell

Yes.

Type some text then hit ALT + ENTER to get a CR.

Type some more text and ALT + ENTER again.

Hit ENTER to leave the cell.

Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 08:06:01 -0700, ulidech
wrote:

I want to put several lines in a cell without word wrapping if the column is
expanded. Can this be done?

All times are GMT +1. The time now is 11:53 PM.