Can I put a carriage return in an EXCEL cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to put several lines in a cell without word wrapping if the column is
expanded. Can this be done?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carriage return displays as a small box 8
Unicode text and carriage returns 4
Excel - carriage returns and formating of text within a cell 2
carriage return in text cell in excell 2
Carriage return during an if statement 4
copying/pasting accurately from a Word table (carriage returns) 1
Replacing carriage returns with a comma 4
Column Header 1

Back
Top