Thanks for the quick reply. Unfortunately, I don't think it answers my
question. The white space isn't selectable, so it doesn't appear to be so.
Also it automatically removes the extra white space when the column is
widened.

"ScottO" wrote:

> Is there any chance that the data import is sucking in some extra spaces on
> the end of your text?
> If so, you may need to use the Trim function to do a cleanup first.
> Rgds,
> ScottO
>
> "bookmike" <bookmike@discussions.microsoft.com> wrote in message
> news:1EB7DDBB-7711-4DB2-8A73-99C4DA86206E@microsoft.com...
> | I am having an issue with autofitting rows in a spreadsheet of imported
> text
> | in Excel 2003. There are no merged cells in the document, and none of the
> | cells go over the 1024 character limit. When I select all rows and attempt
> to
> | autofit the rows to the contents of the cells, some of the rows resize
> | properly, and some leave one or several lines of white space below the
> bottom
> | of the text in the longest cell. I can resize them manually, but this is
> data
> | that is imported daily and runs to several thousand rows. If I widen the
> | column where I am having the problem, once it reaches a certain width
> (which
> | varies), if I re-autofit the selection, it will correct itself. But I am
> | constrained on column width, as there are about 20 columns and I need them
> | all to fit on one 81/2 by 14 landscape page width. Any ideas on what might
> be
> | causing the problem and how to fix it?
> |
> | Thanks.
> | Mike
>
>
>