Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Carriage return within a cell
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Carriage return within a cell
Hold ALT key, then pres ENTER key
Sometime you need to format the cell to permit "Warp Text" (on the Alignment tab) best wsihes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Jon" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Carriage return within a cell
Type Alt-Enter
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jon" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Carriage return within a cell
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 "Jon" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to insert a 'carriage return' in a cell? | Excel Discussion (Misc queries) | |||
Can I put a carriage return in an EXCEL cell | Excel Discussion (Misc queries) | |||
Alt+enter to carriage return within a cell does not work...? | Excel Discussion (Misc queries) | |||
Carriage Return within Cell for MAC users | Excel Discussion (Misc queries) | |||
How do I add a carriage return into a cell in Excel? | Excel Discussion (Misc queries) |