Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height not expanding w/ word wrap
The words are wrapping in a cell, but only the last line of text is visible
b/c the row height didn't change when the words wrapped. How do I fix this? I can manually fix all the rows, but I want data input to work going forward as well and don't want to do manual maintenance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height not expanding w/ word wrap
That is a known problem, you can use a macro to help you
AutoFit rows of merged cells, Jim Rech, programming, 2002-03-26. http://groups.google.com/groups?thre...%40tkmsftngp05 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "JHersko" wrote in message ... The words are wrapping in a cell, but only the last line of text is visible b/c the row height didn't change when the words wrapped. How do I fix this? I can manually fix all the rows, but I want data input to work going forward as well and don't want to do manual maintenance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row height not expanding w/ word wrap
are you typing in merged cells? the autofit does not apply to merged cells.
If you are merging cell try unmerging them and using "center across selection" instead. This can be found by clicking Format-Cells-Alignment and under horizontal alignment there should be a selection "center across selection". if they are not merged, then are you typing a large amount of text in one cell? "JHersko" wrote: The words are wrapping in a cell, but only the last line of text is visible b/c the row height didn't change when the words wrapped. How do I fix this? I can manually fix all the rows, but I want data input to work going forward as well and don't want to do manual maintenance. |
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) | |||
Word wrap problem | Excel Worksheet Functions | |||
Excel adjust row height upon merging 2 cell with word wrap | Excel Discussion (Misc queries) | |||
row height not accounting for wrap text | Excel Discussion (Misc queries) | |||
word wrap not working | Excel Discussion (Misc queries) |