Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Autofit rows - white space.
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 |
#2
|
|||
|
|||
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" wrote in message ... | 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 |
#3
|
|||
|
|||
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" wrote in message ... | 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit makes rows too tall | Excel Discussion (Misc queries) | |||
Autofit makes rows too tall | Excel Discussion (Misc queries) | |||
White Space in a Cell | New Users to Excel | |||
Extra White Space Between Cells | Excel Discussion (Misc queries) | |||
Excel save as htm with functionality too much white space | Excel Discussion (Misc queries) |