Autofit rows - white space.

[bookmike]

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

"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

[bookmike]

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
>
>
>

[Renns]

I am having this same issue in Excel 2010. Any solution?

[Cutter]

Hello Renns, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.