| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells to display 20 long sentences in a single cell
Even if i format the cell (in exel sheet) as wrap text, the cell does not
display long sentences completly. It only displays a part of the sentence. This happens after entering say 20 or more lines. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cells to display 20 long sentences in a single cell
r
From help 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. You could use a text box if this helps -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "r" wrote in message ... Even if i format the cell (in exel sheet) as wrap text, the cell does not display long sentences completly. It only displays a part of the sentence. This happens after entering say 20 or more lines. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cells to display 20 long sentences in a single cell
If you add alt-enters every 80-100 characters to force new lines within the
cell, you'll see lots more characters. r wrote: Even if i format the cell (in exel sheet) as wrap text, the cell does not display long sentences completly. It only displays a part of the sentence. This happens after entering say 20 or more lines. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Issue | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Linear Mode
