cells stop accepting text after 1801 characters

  • Thread starter Thread starter Carl Gross
  • Start date Start date
C

Carl Gross

Someone in my office tried inserting text characters into
a cell in a worksheet. After 1801 characters, it quit
entering text.

The cell is formatted as a merged cell (merged to what, I
can't tell) with text wrap, and is locked.

Why can't my person enter more charcters.
 
You can have a cell that contains about 32k worth of characters, but left to its
own devices, excel will only show about 1000.

You can add alt-enters to force new lines within your cell and you can see more.

But with mergedcells, you'll have to adjust the rowheight yourself--it won't
react nicely to autofitting the rowheight.
 
Back
Top