| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Word Wrap and extending cell/row/column size
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 formatcolumnautofit doesn't seem to work cheers. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Word Wrap and extending cell/row/column size
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. kippers wrote: 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 formatcolumnautofit doesn't seem to work cheers. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
| Getting word wrap to work in a merged cell | Excel Discussion (Misc queries) | |||
| Why am I getting XXX error in text cell with word wrap turned on? | Excel Discussion (Misc queries) | |||
| how do I get alt-enter to expand word wrap cell | Excel Discussion (Misc queries) | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
Linear Mode
