Text Wrap

User has a cell that is set for text wrap. She has textwrap in that the last
line will not show up. Have increased cell height, but text does not show.
Have gotten text to show, but only by widening the cell. This is not an
option because the columns will not fit on one page then. Row height is not
an issue, except that not all of the text will show no matter the height you
make the cell. Does Excel have a limitation on the number of characters can
be in a cell and would this limitation be negated by increasing the width of
the cell/column?

If you add some alt-enters (every 80-100 characters) in that cell, can you see
everything--you may have to resize that rowheight manually, though.

holy dog wrote:
>
> User has a cell that is set for text wrap. She has textwrap in that the last
> line will not show up. Have increased cell height, but text does not show.
> Have gotten text to show, but only by widening the cell. This is not an
> option because the columns will not fit on one page then. Row height is not
> an issue, except that not all of the text will show no matter the height you
> make the cell. Does Excel have a limitation on the number of characters can
> be in a cell and would this limitation be negated by increasing the width of
> the cell/column?

--

Dave Peterson

Thank you. I tested this and it works, although the user insists that she
should not need to do this. Oh well.

"Dave Peterson" wrote:

> If you add some alt-enters (every 80-100 characters) in that cell, can you see
> everything--you may have to resize that rowheight manually, though.
>
> holy dog wrote:
> >
> > User has a cell that is set for text wrap. She has textwrap in that the last
> > line will not show up. Have increased cell height, but text does not show.
> > Have gotten text to show, but only by widening the cell. This is not an
> > option because the columns will not fit on one page then. Row height is not
> > an issue, except that not all of the text will show no matter the height you
> > make the cell. Does Excel have a limitation on the number of characters can
> > be in a cell and would this limitation be negated by increasing the width of
> > the cell/column?
>
> --
>
> Dave Peterson
>

Did you insist that you shouldn't have to pay taxes?

<vbg>

holy dog wrote:
>
> Thank you. I tested this and it works, although the user insists that she
> should not need to do this. Oh well.
>
> "Dave Peterson" wrote:
>
> > If you add some alt-enters (every 80-100 characters) in that cell, can you see
> > everything--you may have to resize that rowheight manually, though.
> >
> > holy dog wrote:
> > >
> > > User has a cell that is set for text wrap. She has textwrap in that the last
> > > line will not show up. Have increased cell height, but text does not show.
> > > Have gotten text to show, but only by widening the cell. This is not an
> > > option because the columns will not fit on one page then. Row height is not
> > > an issue, except that not all of the text will show no matter the height you
> > > make the cell. Does Excel have a limitation on the number of characters can
> > > be in a cell and would this limitation be negated by increasing the width of
> > > the cell/column?
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

NO, I wish I would have thought of it then, but then you know the customer is
always right even when they are wrong. I appreciate the help. Thank You
Holy Dog

"Dave Peterson" wrote:

> Did you insist that you shouldn't have to pay taxes?
>
> <vbg>
>
> holy dog wrote:
> >
> > Thank you. I tested this and it works, although the user insists that she
> > should not need to do this. Oh well.
> >
> > "Dave Peterson" wrote:
> >
> > > If you add some alt-enters (every 80-100 characters) in that cell, can you see
> > > everything--you may have to resize that rowheight manually, though.
> > >
> > > holy dog wrote:
> > > >
> > > > User has a cell that is set for text wrap. She has textwrap in that the last
> > > > line will not show up. Have increased cell height, but text does not show.
> > > > Have gotten text to show, but only by widening the cell. This is not an
> > > > option because the columns will not fit on one page then. Row height is not
> > > > an issue, except that not all of the text will show no matter the height you
> > > > make the cell. Does Excel have a limitation on the number of characters can
> > > > be in a cell and would this limitation be negated by increasing the width of
> > > > the cell/column?
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

Alt+Enter does gain you an automatic text wrap, but

You probably want to know why the Alt-Enter is needed in some cases
but not in most cases when cell wrap is already turned on.

If you look in HELP you will see that it indicates .under "specification" (specification limits)

Length of cell contents (text)
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

By using Alt+Enter you can display over 1,024 chars (and/or spaces) in a cell, one
case where specification limits apparently were incorrectly/incompletely documented.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"holy dog" <holydog@discussions.microsoft.com> wrote in message news:66E981A5-9C23-4FE6-AA68-68E15627DE12@microsoft.com...
> NO, I wish I would have thought of it then, but then you know the customer is
> always right even when they are wrong. I appreciate the help. Thank You
> Holy Dog
>
> "Dave Peterson" wrote:
>
> > Did you insist that you shouldn't have to pay taxes?
> >
> > <vbg>
> >
> > holy dog wrote:
> > >
> > > Thank you. I tested this and it works, although the user insists that she
> > > should not need to do this. Oh well.
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > If you add some alt-enters (every 80-100 characters) in that cell, can you see
> > > > everything--you may have to resize that rowheight manually, though.
> > > >
> > > > holy dog wrote:
> > > > >
> > > > > User has a cell that is set for text wrap. She has textwrap in that the last
> > > > > line will not show up. Have increased cell height, but text does not show.
> > > > > Have gotten text to show, but only by widening the cell. This is not an
> > > > > option because the columns will not fit on one page then. Row height is not
> > > > > an issue, except that not all of the text will show no matter the height you
> > > > > make the cell. Does Excel have a limitation on the number of characters can
> > > > > be in a cell and would this limitation be negated by increasing the width of
> > > > > the cell/column?
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

Thanks, I looked under the help, but did not check specifications. I do
appreciate the assistance and have learned much from you all. These NGs are
the greatest thing since sliced bread

"David McRitchie" wrote:

> Alt+Enter does gain you an automatic text wrap, but
>
> You probably want to know why the Alt-Enter is needed in some cases
> but not in most cases when cell wrap is already turned on.
>
> If you look in HELP you will see that it indicates .under "specification" (specification limits)
>
> Length of cell contents (text)
> 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
>
> By using Alt+Enter you can display over 1,024 chars (and/or spaces) in a cell, one
> case where specification limits apparently were incorrectly/incompletely documented.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "holy dog" <holydog@discussions.microsoft.com> wrote in message news:66E981A5-9C23-4FE6-AA68-68E15627DE12@microsoft.com...
> > NO, I wish I would have thought of it then, but then you know the customer is
> > always right even when they are wrong. I appreciate the help. Thank You
> > Holy Dog
> >
> > "Dave Peterson" wrote:
> >
> > > Did you insist that you shouldn't have to pay taxes?
> > >
> > > <vbg>
> > >
> > > holy dog wrote:
> > > >
> > > > Thank you. I tested this and it works, although the user insists that she
> > > > should not need to do this. Oh well.
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > If you add some alt-enters (every 80-100 characters) in that cell, can you see
> > > > > everything--you may have to resize that rowheight manually, though.
> > > > >
> > > > > holy dog wrote:
> > > > > >
> > > > > > User has a cell that is set for text wrap. She has textwrap in that the last
> > > > > > line will not show up. Have increased cell height, but text does not show.
> > > > > > Have gotten text to show, but only by widening the cell. This is not an
> > > > > > option because the columns will not fit on one page then. Row height is not
> > > > > > an issue, except that not all of the text will show no matter the height you
> > > > > > make the cell. Does Excel have a limitation on the number of characters can
> > > > > > be in a cell and would this limitation be negated by increasing the width of
> > > > > > the cell/column?
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
>
>