| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a new line of text within a cell on excel?
i need to type one big load of text into one cell i can't merge them etc
please anyone that can help get in touch cheers! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i create a new line of text within a cell on excel?
use Alt+Enter after each end of line. Caveat: excel limit and
specifications shows this line: Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar "laurac85" wrote in message ... i need to type one big load of text into one cell i can't merge them etc please anyone that can help get in touch cheers! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i create a new line of text within a cell on excel?
Adding those alt-enters every 80-100 characters breaks the 1024 characters
displayed in the cell specification. You'll be able to see lots more. JON JON wrote: use Alt+Enter after each end of line. Caveat: excel limit and specifications shows this line: Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar "laurac85" wrote in message ... i need to type one big load of text into one cell i can't merge them etc please anyone that can help get in touch cheers! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get selected text within a cell to remain bold in excel? | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| Just one cell in an Excel column won't text wrap. | New Users to Excel | |||
| Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
