software

I have created a form and it appears that there is a restirction on the
number of lines/characters that can go in this merged area. I am set up
as merged/wrap text/shrink to fit but after 8 lines, any following data
entered goes off the form as if quot;wrap textquot; is not there. Also, it
doesn't show up on print preview. How can I get around this, as the
requirement for this form may be much more than 8 lines?

Bob--
RERICE
------------------------------------------------------------------------
RERICE's Profile: www.excelforum.com/member.php...oamp;userid=34008
View this thread: www.excelforum.com/showthread...hreadid=537705RERICE,

It's my understanding that merging cells in Excel is not desirable. If you
need to make a form, its better to use borders to create regions, and
include as many cells in the borders as you need for aesthetics. You can use
quot;center across selectionquot; to fine-tune some of your text positioning, and
turn off gridlines as your form is designed, leaving the borders you turned
on to view and print. HTH

Beege

quot;RERICEquot; gt; wrote in
message ...
gt;
gt; I have created a form and it appears that there is a restirction on the
gt; number of lines/characters that can go in this merged area. I am set up
gt; as merged/wrap text/shrink to fit but after 8 lines, any following data
gt; entered goes off the form as if quot;wrap textquot; is not there. Also, it
gt; doesn't show up on print preview. How can I get around this, as the
gt; requirement for this form may be much more than 8 lines?
gt;
gt; Bob
gt;
gt;
gt; --
gt; RERICE
gt; ------------------------------------------------------------------------
gt; RERICE's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34008
gt; View this thread: www.excelforum.com/showthread...hreadid=537705
gt;
Per Help/Specifications, each cell will display only the first 1024
characters (even if merged). You can get around this by manually
entering a line feed character (Option-Enter) at least every 1024 chars.

In article gt;,
RERICE gt; wrote:

gt; I have created a form and it appears that there is a restirction on the
gt; number of lines/characters that can go in this merged area. I am set up
gt; as merged/wrap text/shrink to fit but after 8 lines, any following data
gt; entered goes off the form as if quot;wrap textquot; is not there. Also, it
gt; doesn't show up on print preview. How can I get around this, as the
gt; requirement for this form may be much more than 8 lines?
gt;
gt; Bob


Too late-the form has been created with merged cells and is in use. Is
there a way to get around the problem I'm seeing with the restriction
in # of lines?

Bob--
RERICE
------------------------------------------------------------------------
RERICE's Profile: www.excelforum.com/member.php...oamp;userid=34008
View this thread: www.excelforum.com/showthread...hreadid=537705
JE McGimpsey Wrote:
gt; Per Help/Specifications, each cell will display only the first 1024
gt; characters (even if merged). You can get around this by manually
gt; entering a line feed character (Option-Enter) at least every 1024
gt; chars.
gt;
gt; In article gt;,
gt; RERICE gt; wrote:
gt;
gt; gt; I have created a form and it appears that there is a restirction on
gt; the
gt; gt; number of lines/characters that can go in this merged area. I am set
gt; up
gt; gt; as merged/wrap text/shrink to fit but after 8 lines, any following
gt; data
gt; gt; entered goes off the form as if quot;wrap textquot; is not there. Also, it
gt; gt; doesn't show up on print preview. How can I get around this, as the
gt; gt; requirement for this form may be much more than 8 lines?
gt; gt;
gt; gt; Bob
what keystrokes do I use for the linefeed?--
RERICE
------------------------------------------------------------------------
RERICE's Profile: www.excelforum.com/member.php...oamp;userid=34008
View this thread: www.excelforum.com/showthread...hreadid=537705Opt/Alt-Enter

In article gt;,
RERICE gt; wrote:

gt; what keystrokes do I use for the linefeed?