Row height AutoFit help

[Machinist60]

I have an Excel 2007 text table 3 columns by 1000+ rows. Many cell entries
are more than one line. Some are only one line of text in all cells in the
row. When global autofit for row height is applied, some of the rows with
single line cell entries are adjusted as if there are two lines of text in
one of the cells. I assume there must be a non printable character
somewhere in the row. The entries were usually copy/pasted in.

I there a way to detect these or is something else going on?

Thanks, John.

 

[Machinist60]

I have an Excel 2007 text table 3 columns by 1000+ rows. Many cell
entries are more than one line. Some are only one line of text in all
cells in the row. When global autofit for row height is applied, some of
the rows with single line cell entries are adjusted as if there are two
lines of text in one of the cells. I assume there must be a non printable
character somewhere in the row. The entries were usually copy/pasted in.

I there a way to detect these or is something else going on?

Thanks, John.

After a more exhaustive Google search using the correct terms it seems this
has been an ongoing problem for years with nothing done to correct it.