| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I type long paragraph into a cell?
I am doing a chart with 3 columns -Date, Apt. No. and Complaint. The
complaint column is about 5 inches wide but I need to be able to add more rows in the cell. After typing approximately 15+ lines it will not take any more data. If I add the additional data to the edit line at the top it will not appear in the chart and it will not print. I tried starting on the following line in a new cell but then when I try sorting the information, it does not stay in order. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I type long paragraph into a cell?
Try throwing in an Alt+Enter (which gives a new line) from time to time.
[And I assume you mean a worksheet, not a chart?] -- David Biddulph "Sunshine" wrote in message ... I am doing a chart with 3 columns -Date, Apt. No. and Complaint. The complaint column is about 5 inches wide but I need to be able to add more rows in the cell. After typing approximately 15+ lines it will not take any more data. If I add the additional data to the edit line at the top it will not appear in the chart and it will not print. I tried starting on the following line in a new cell but then when I try sorting the information, it does not stay in order. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I type long paragraph into a cell?
I tried this and it works to add alot of information on the formula line, but
the longer paragraphs do not appear in the "worksheet" cell and it also will not print. Now what - maybe Excel is just not made for this type of data. "Sunshine" wrote: I am doing a chart with 3 columns -Date, Apt. No. and Complaint. The complaint column is about 5 inches wide but I need to be able to add more rows in the cell. After typing approximately 15+ lines it will not take any more data. If I add the additional data to the edit line at the top it will not appear in the chart and it will not print. I tried starting on the following line in a new cell but then when I try sorting the information, it does not stay in order. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I type long paragraph into a cell?
You can enter 32,767 characters in a cell.
Unfortunately only about 1024 will show or print. If you add an Alt + Enter every 100 characters you can increase this limit. BTW...............merging multiple cells does not increase this limit. You still have one cell. Insert a screen-sized textbox from the Control Toolbox for your needs. Gord Dibben MS Excel MVP On Fri, 12 Oct 2007 17:08:02 -0700, Sunshine wrote: I tried this and it works to add alot of information on the formula line, but the longer paragraphs do not appear in the "worksheet" cell and it also will not print. Now what - maybe Excel is just not made for this type of data. "Sunshine" wrote: I am doing a chart with 3 columns -Date, Apt. No. and Complaint. The complaint column is about 5 inches wide but I need to be able to add more rows in the cell. After typing approximately 15+ lines it will not take any more data. If I add the additional data to the edit line at the top it will not appear in the chart and it will not print. I tried starting on the following line in a new cell but then when I try sorting the information, it does not stay in order. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't see all of the paragraph text in the cell. | Excel Discussion (Misc queries) | |||
| Excel - long paragraph across multiple cells | Excel Discussion (Misc queries) | |||
| Starting a new paragraph within a cell | Excel Discussion (Misc queries) | |||
| How do I add a make a new paragraph in a text cell? | Excel Discussion (Misc queries) | |||
| how do i make a paragraph appear in one cell area? | Excel Worksheet Functions | |||
Linear Mode
