word wrapped text does not completely display

  • Thread starter Thread starter wsjanus
  • Start date Start date
W

wsjanus

I am working with test data in a spreadsheet. Some of the cells are quire
lengthy and don't completely display in the sheet - even though they are word
wrapped. Making the column wider does not solve the problem. Any
suggestions appreciated.
 
hi
how much is lengthy?
each cell should hold up to 32767 characters but only 1024 with show in the
cell. the rest should appear in the formula bar.

regards
FSt1
 
If your lengthy text entry is in a merged cell you'll have to adjust the row
height manually as Excel does not do this with merged cells, even with word
wrap turned on.
 
You'll see about 1000 characters in the cell unless you do something special.

You can add alt-enters (to force new lines within the cell) every 80-100
characters to see lots more than those 1000 characters.
 
Back
Top