Word wrapping paragraphs within cells

[Anthony Little]

Hi everyone,

I support a user who stores narrative data within a spreadsheet. They want
to know why Excel 2000 SR-1 inconsistently wraps text within a cell after
the narrative exceeds 8 lines. This occurs regardless of cell height. They
also want to know how to fix it so the text wraps consistently regardless of
narrative length.

I know the obvious answer (store the data somewhere else) - but does anyone
have any more politically acceptable ideas?


Thanks in advance.

 

[Dave Peterson]

I don't store that much text in cells, but you may want to have them try putting
some alt-enters in their text.

Excel's help shows that about 1000 characters will show in the cell (of the
about 32k characters that will show in the formula bar).

With the alt-enters mixed in, excel can show more text. Maybe a little test
will tell them if it's worth proceeding.

And any thought of a text box or using word (maybe Insert|object)????

 

[Anthony Little]

Thanks Dave - I'll see how it goes.

I don't store that much text in cells, but you may want to have them try putting
some alt-enters in their text.

Excel's help shows that about 1000 characters will show in the cell (of the
about 32k characters that will show in the formula bar).

With the alt-enters mixed in, excel can show more text. Maybe a little test
will tell them if it's worth proceeding.

And any thought of a text box or using word (maybe Insert|object)????