Well, this isn't truly programming, but someone here can maybe help me with
this? I have auto row height set for one whole sheet. One column tends to
get most of the data (text) so it tends to govern the row height. I have one
row, and this happens off and on it seems with various rows similar to this,
where I have say 15 wrapped lines of text, but autofit is cutting off say 5
more lines that should be there. They read fine in the formula bar, but
don't show in the cell.

Is this an Excel bug of some kind, or is something affecting it? I think the
format is simply general for contents. What else could be the issue?

Thanks!

--Randy Starkey

As a follow up to this, it seems Excel has a character limit as to what it
will display in a cell. I'm around 1800 characters, and it seems to simply
refuse to display any more in the cell. They show in the formula bar fine,
and when you double click the cell, but when you go back to normal display,
only the first 1800 or whatever will display. You can double the row height
and still only up to a certain number will display.

Anyone know of workarounds?

Thanks!

--Randy Starkey


"Randy Starkey" wrote in
message ...
Well, this isn't truly programming, but someone here can maybe help me
with this? I have auto row height set for one whole sheet. One column
tends to get most of the data (text) so it tends to govern the row height.
I have one row, and this happens off and on it seems with various rows
similar to this, where I have say 15 wrapped lines of text, but autofit is
cutting off say 5 more lines that should be there. They read fine in the
formula bar, but don't show in the cell.

Is this an Excel bug of some kind, or is something affecting it? I think
the format is simply general for contents. What else could be the issue?

Thanks!

--Randy Starkey

It sounds like you've simply exceeded the cell limit after which it won't
wrap any more. I seem to recollect it's 1024 characters.

Regards,
Greg

"Randy Starkey" wrote:

Well, this isn't truly programming, but someone here can maybe help me with
this? I have auto row height set for one whole sheet. One column tends to
get most of the data (text) so it tends to govern the row height. I have one
row, and this happens off and on it seems with various rows similar to this,
where I have say 15 wrapped lines of text, but autofit is cutting off say 5
more lines that should be there. They read fine in the formula bar, but
don't show in the cell.

Is this an Excel bug of some kind, or is something affecting it? I think the
format is simply general for contents. What else could be the issue?

Thanks!

--Randy Starkey

Looks like the actual limit is 1024, and I can't find any way around it (for
displaying in the cell)

See http://support.microsoft.com/default...-us;211580#kb1

If anyone knows any tricks, it would be appreciated. The note says display
settings could affect this - whatever THAT means!

--Randy Starkey


"Randy Starkey" wrote in
message ...
Well, this isn't truly programming, but someone here can maybe help me
with this? I have auto row height set for one whole sheet. One column
tends to get most of the data (text) so it tends to govern the row height.
I have one row, and this happens off and on it seems with various rows
similar to this, where I have say 15 wrapped lines of text, but autofit is
cutting off say 5 more lines that should be there. They read fine in the
formula bar, but don't show in the cell.

Is this an Excel bug of some kind, or is something affecting it? I think
the format is simply general for contents. What else could be the issue?

Thanks!

--Randy Starkey

Randy

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.

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.


Gord Dibben Excel MVP




On Tue, 22 Mar 2005 01:19:46 -0600, "Randy Starkey"
wrote:

Looks like the actual limit is 1024, and I can't find any way around it (for
displaying in the cell)

See http://support.microsoft.com/default...-us;211580#kb1

If anyone knows any tricks, it would be appreciated. The note says display
settings could affect this - whatever THAT means!

--Randy Starkey


"Randy Starkey" wrote in
message ...
Well, this isn't truly programming, but someone here can maybe help me
with this? I have auto row height set for one whole sheet. One column
tends to get most of the data (text) so it tends to govern the row height.
I have one row, and this happens off and on it seems with various rows
similar to this, where I have say 15 wrapped lines of text, but autofit is
cutting off say 5 more lines that should be there. They read fine in the
formula bar, but don't show in the cell.

Is this an Excel bug of some kind, or is something affecting it? I think
the format is simply general for contents. What else could be the issue?

Thanks!

--Randy Starkey

Wow! Thanks. I'll experiment.

--Randy Starkey


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Randy

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.

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.


Gord Dibben Excel MVP




On Tue, 22 Mar 2005 01:19:46 -0600, "Randy Starkey"
wrote:

Looks like the actual limit is 1024, and I can't find any way around it
(for
displaying in the cell)

See http://support.microsoft.com/default...-us;211580#kb1

If anyone knows any tricks, it would be appreciated. The note says display
settings could affect this - whatever THAT means!

--Randy Starkey


"Randy Starkey" wrote in
message ...
Well, this isn't truly programming, but someone here can maybe help me
with this? I have auto row height set for one whole sheet. One column
tends to get most of the data (text) so it tends to govern the row
height.
I have one row, and this happens off and on it seems with various rows
similar to this, where I have say 15 wrapped lines of text, but autofit
is
cutting off say 5 more lines that should be there. They read fine in the
formula bar, but don't show in the cell.

Is this an Excel bug of some kind, or is something affecting it? I think
the format is simply general for contents. What else could be the issue?

Thanks!

--Randy Starkey

Gord,

Tried it, but the data didn't expand - seems to be hard coded at 1024. The
new blank line showed up, but the number of characters didn't increase.Am I
missing anything?

--Randy

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Randy

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.

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.


Gord Dibben Excel MVP




On Tue, 22 Mar 2005 01:19:46 -0600, "Randy Starkey"
wrote:

Looks like the actual limit is 1024, and I can't find any way around it
(for
displaying in the cell)

See http://support.microsoft.com/default...-us;211580#kb1

If anyone knows any tricks, it would be appreciated. The note says display
settings could affect this - whatever THAT means!

--Randy Starkey


"Randy Starkey" wrote in
message ...
Well, this isn't truly programming, but someone here can maybe help me
with this? I have auto row height set for one whole sheet. One column
tends to get most of the data (text) so it tends to govern the row
height.
I have one row, and this happens off and on it seems with various rows
similar to this, where I have say 15 wrapped lines of text, but autofit
is
cutting off say 5 more lines that should be there. They read fine in the
formula bar, but don't show in the cell.

Is this an Excel bug of some kind, or is something affecting it? I think
the format is simply general for contents. What else could be the issue?

Thanks!

--Randy Starkey