| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter text in two line in a excel cell
Hey Giggs,
Could you help me to enter 2 lines text in a excel cell without using space bar. Like we can write in Word. By pasting the texts coped from word, it works, but i wanna know whether we can enter 2 line texts in an excel single cell. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to enter text in two line in a excel cell
Alt+Enter, and format/cells/alignment to permit word wrap.
-- David Biddulph "Pra" wrote in message ... Hey Giggs, Could you help me to enter 2 lines text in a excel cell without using space bar. Like we can write in Word. By pasting the texts coped from word, it works, but i wanna know whether we can enter 2 line texts in an excel single cell. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to enter text in two line in a excel cell
Separate them with Alt-Enter
-- __________________________________ HTH Bob "Pra" wrote in message ... Hey Giggs, Could you help me to enter 2 lines text in a excel cell without using space bar. Like we can write in Word. By pasting the texts coped from word, it works, but i wanna know whether we can enter 2 line texts in an excel single cell. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I enter more than one line in the same Excel Cell by using. | Excel Discussion (Misc queries) | |||
| How to enter a return key stroke within a cell (new line of text) | Excel Discussion (Misc queries) | |||
| How to enter an Excel cell reference into a line of text in Excel | Excel Worksheet Functions | |||
| Can you enter a new line in an individual cell within Excel | Excel Discussion (Misc queries) | |||
| How can I create a new line in a cell in Excel by hitting enter? | Excel Discussion (Misc queries) | |||
Linear Mode
