View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default 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.