Cell text limitations in Excel 97

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

Has anyone encountered text limitations in a cell in Excel
97? The formatting is minimal: text is top aligned and
the 'wrap text' is engaged.

It wraps until a certain point and then no longer. Even
when the width of the cell is widened, text is still
hidden. Text can be viewed in the formula bar when single-
clicking the cell. But is partially hidden from view in
Normal view and when printed.

I saw in the Knowledge Base that text is truncated to 255
characters or less if the text is 'justified' but this is
merely top-aligned.

Appreciate any assistance! Laura
 
Has anyone encountered text limitations in a cell in Excel
97? The formatting is minimal: text is top aligned and
the 'wrap text' is engaged.

It wraps until a certain point and then no longer. Even
when the width of the cell is widened, text is still
hidden. Text can be viewed in the formula bar when single-
clicking the cell. But is partially hidden from view in
Normal view and when printed.
Click to expand...
...

Embed some newline characters in this cell's contents. For example, to change

Now is the time for all good quick brown foxes to jump over lazy dogs in order
to come the aid of their country.

into

Now is the time for all good quick brown
foxes to jump over lazy dogs in order to
come the aid of their country.

edit the cell, move the cursor to just before the 'f' in foxes, hold down an
[Alt] key and press the [Enter] key, then repeat with the cursor just before the
'c' in come. That is, use [Alt]+[Enter] enters newlines into cell contents in
the formula bar. With regularly spaced newlines embedded in cell contents, Excel
will display many more characters than it claims it can.
 
Excel 97 can hold as many characters as you can type in
a cell, but can only display 1,024 characters per cell in
a worksheet. If you click the cell and view the formula
bar, you see the entire contents.

A quick way to work around this is to divide the text
between two cells if your text exceeds the 1,024
character limit.

Hope this helps!
 
If you leave excel to its own devices, you'll see about 1000 characters in that
cell. But if you pepper a few alt-enters (to force new lines at nice spots),
you can see more.
 
Back
Top