Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does the Wrap function in excel allow a maximum number of lines?
We are typing text into a cell --- after 8 lines of text it will no longer
wrap -- is there a maximum number of lines excel will display? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does the Wrap function in excel allow a maximum number of lines?
There is a limitation in Excel as far as wrap text and visible text is
concerned. In excels own help files the following can be found under Excel specifications and limits: Length of cell contents:- 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. So, display is limited to 1024 cells Regards Philip "Redskins Fan" <Redskins wrote in message ... We are typing text into a cell --- after 8 lines of text it will no longer wrap -- is there a maximum number of lines excel will display? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does the Wrap function in excel allow a maximum number of lines?
Hi Redskins Fan, I guess. You can extend the viewable size in a cell by
entering hard carriage returns periodically, say after every 3rd row. When you want to add a line, hit alt-enter. HTH -- Sincerely, Michael Colvin "Redskins Fan" wrote: We are typing text into a cell --- after 8 lines of text it will no longer wrap -- is there a maximum number of lines excel will display? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does the Wrap function in excel allow a maximum number of lines?
Add alt-enters (to force new lines within the cell) every 80 or 100 characters.
You'll see lots more than the documented 1024 characters. Redskins Fan wrote: We are typing text into a cell --- after 8 lines of text it will no longer wrap -- is there a maximum number of lines excel will display? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Excel have a limit on lines it will wrap in a cell? | Excel Discussion (Misc queries) | |||
Some lines of text in Excel field do not wrap text. Please help. | Excel Discussion (Misc queries) | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |