Autofit rows - white space.

[Guest]

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

 

[ScottO]

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

| 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

 

[Guest]

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.