Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
word wrap in excel
Word wrap works great for the majority of my document, but for cells
containing more text (over 10 lines or so) the word wrap does not work, and portions of the text is hidden from view. Has anyone else experienced this problem? Thanks, jc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
word wrap in excel
jeremy
It is not a word-wrap problem. It is a character-limit per cell problem. 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 Tue, 25 Apr 2006 16:22:02 -0700, jeremy wrote: Word wrap works great for the majority of my document, but for cells containing more text (over 10 lines or so) the word wrap does not work, and portions of the text is hidden from view. Has anyone else experienced this problem? Thanks, jc Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
word wrap in excel
Thanks Gordon. I will try that.
Jeremy "Gord Dibben" wrote: jeremy It is not a word-wrap problem. It is a character-limit per cell problem. 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 Tue, 25 Apr 2006 16:22:02 -0700, jeremy wrote: Word wrap works great for the majority of my document, but for cells containing more text (over 10 lines or so) the word wrap does not work, and portions of the text is hidden from view. Has anyone else experienced this problem? Thanks, jc Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
Entering Excel information into MS Word | Excel Discussion (Misc queries) |