Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |