Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncated wrapped text cells in Excel
I have a problem with displaying and printing very long wrapped text cells on
a spreadsheet. When the length of the text string goes beyond a certain limit, Excel truncates the displayed text, even if there is sufficient room to display the text in the cell. Is there any way around this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncated wrapped text cells in Excel
Rich
Excel Help on "limits" or "specifications" reveals that Excel will allow 32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots, about every 100 characters.. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy" And adjusted the columnwidth, rowheight and font size and I got about 7300 characters to print ok. .........End Dave P................. Failing that, use a Text Box to store the text or MS Word which is a word processing application, unlike Excel which is not. Gord Dibben Excel MVP On Wed, 12 Apr 2006 10:37:01 -0700, RichK wrote: I have a problem with displaying and printing very long wrapped text cells on a spreadsheet. When the length of the text string goes beyond a certain limit, Excel truncates the displayed text, even if there is sufficient room to display the text in the cell. Is there any way around this? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |