software

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.

That is a known problem, you can use a macro to help you
AutoFit rows of merged cells, Jim Rech, programming, 2002-03-26.
groups.google.com/groups?thre...@tkmsftngp05
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;JHerskoquot; gt; wrote in message ...
gt; The words are wrapping in a cell, but only the last line of text is visible
gt; b/c the row height didn't change when the words wrapped. How do I fix this?
gt; I can manually fix all the rows, but I want data input to work going forward
gt; as well and don't want to do manual maintenance.
are you typing in merged cells? the autofit does not apply to merged cells.
If you are merging cell try unmerging them and using quot;center across
selectionquot; instead. This can be found by clicking Format-gt;Cells-gt;Alignment
and under horizontal alignment there should be a selection quot;center across
selectionquot;.

if they are not merged, then are you typing a large amount of text in one
cell?

quot;JHerskoquot; wrote:

gt; The words are wrapping in a cell, but only the last line of text is visible
gt; b/c the row height didn't change when the words wrapped. How do I fix this?
gt; I can manually fix all the rows, but I want data input to work going forward
gt; as well and don't want to do manual maintenance.