| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering text in cells
How do I enter multi-line text (such as a 3 line address) in a cell without
having to use the space bar to move the cursor to the right of the cell so that the next line will be below the previous line? -- PDH |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering text in cells
You can hit alt-enter to force a new line within that cell.
Hallway wrote: How do I enter multi-line text (such as a 3 line address) in a cell without having to use the space bar to move the cursor to the right of the cell so that the next line will be below the previous line? -- PDH -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering text in cells
When you want to change a new line within a cell. Just simple hold "Alt" key + Enter Try it!! 0l0 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering text in cells
That does it...thanks very much...is there a way to program a single key to
do the same thing? -- PDH "Dave Peterson" wrote: You can hit alt-enter to force a new line within that cell. Hallway wrote: How do I enter multi-line text (such as a 3 line address) in a cell without having to use the space bar to move the cursor to the right of the cell so that the next line will be below the previous line? -- PDH -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering text in cells
Not while you're editting the cell (macros won't run).
But you could use some unique character (say the vertical bar |) and then come back and select all the cells with that character and edit|replace what: | with: ctrl-j replace all But I've found hitting ctrl-enter (two keys) not really too difficult to master. Hallway wrote: That does it...thanks very much...is there a way to program a single key to do the same thing? -- PDH "Dave Peterson" wrote: You can hit alt-enter to force a new line within that cell. Hallway wrote: How do I enter multi-line text (such as a 3 line address) in a cell without having to use the space bar to move the cursor to the right of the cell so that the next line will be below the previous line? -- PDH -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum multiple cells with different numbers and text. | Excel Discussion (Misc queries) | |||
| Can't see text in cells | Excel Discussion (Misc queries) | |||
| Cells within a list to display a certain text but have different v | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Linear Mode
