Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit cuts off part of text when printed
Hi,
I have wrapped text and autofit cells in my worksheet. When I print off the worksheet, the last line in each cell is partially cut off. I adjusted the rows manually to enusre my text is not partially cut off, but now, the wrap text feature is not adjusting the cells to fit the text. Help!! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit cuts off part of text when printed
Kim
Perhaps it quits appearing because you have reached the cell limit for viewable/printable characters. 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 Fri, 29 Sep 2006 10:09:02 -0700, KimS546 wrote: Hi, I have wrapped text and autofit cells in my worksheet. When I print off the worksheet, the last line in each cell is partially cut off. I adjusted the rows manually to enusre my text is not partially cut off, but now, the wrap text feature is not adjusting the cells to fit the text. Help!! Thanks! Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit cuts off part of text when printed
Hi Gord,
No, I have not reached my limit....there only only about 30 characters in each cell... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofit cuts off part of text when printed
Is this happening in "merged cells"?
Excel has a problem autofitting merged cells. Manually size the rows. Gord On Mon, 2 Oct 2006 09:00:01 -0700, KimS546 wrote: Hi Gord, No, I have not reached my limit....there only only about 30 characters in each cell... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Wrap text and row autofit not working in Excel | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
Text Cuts Off | Excel Discussion (Misc queries) |