Carriage return within a cell

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

Guest

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?
 
Hold ALT key, then pres ENTER key
Sometime you need to format the cell to permit "Warp Text" (on the Alignment
tab)
best wsihes
 
Type Alt-Enter

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
 
Back
Top