Carriage return within a cell

J

Jon

I would need to skip a line (i.e. move the cursor to the start of the next
return, as when feeding a carriage return), when I'm typing a multiline cell.
Any idea how to do this please?
 
B

Bernard Liengme

Hold ALT key, then pres ENTER key
Sometime you need to format the cell to permit "Warp Text" (on the Alignment
tab)
best wsihes
 
B

Bob Phillips

Type Alt-Enter

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
C

challa prabhu

Hi,

Do the following:
1. Click a Cell
2. Press F2 to enter text and then Press Alt+Enter. This will add a new line
and accordingly extend the widh of the cell.

Note: Pressing Alt+Enter inserts a paragraph at the end of the sentence.
Therefore, you can use different font name, font size, color and other
attributes to each word in a sentence.

Important: There is no Show All icon available in Excel to view the hidden
character in the worksheet.

Challa Prabhu
 

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

Top