Word Wrap and extending cell/row/column size

[kippers]

Hi,

I am developing a template and need cells to expand accordingly when
required in relation to the amount of text entered by users. I have applied
word wrap to all cells but if too much text is addedd outside the current
cell size, the text is lost and the cell doesnlt automatically expmand- any
ideas?!

even format>column>autofit doesn't seem to work

cheers.

 

[Dave Peterson]

If you add alt-enters (to force new lines within the cell) every 80-100
characters, you should be able to see more characters.

And the rowheight should expand (if you haven't manually set that rowheight).

And if you're using mergedcells, autofitting the rowheight won't work right.
You'll have to manually adjust it.