ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Blank line in cells (https://www.excelbanter.com/excel-discussion-misc-queries/42055-blank-line-cells.html)

Dan

Blank line in cells
 
I am having trouble with the autofit row height in Excell XP. It seems that
when my last line of text in a cell is up to 5 characters short of the end of
the cell Excel automatically enters another line as if the previous line was
to long. I know a work around would be to manually adjust the height, but I
could find myself in trouble if text were added to those cells.

Jim Rech

This is a true Excel annoyance. I don't think there is a way to get the
right row height and keep the autofit working.

--
Jim
"Dan" wrote in message
...
|I am having trouble with the autofit row height in Excell XP. It seems
that
| when my last line of text in a cell is up to 5 characters short of the end
of
| the cell Excel automatically enters another line as if the previous line
was
| to long. I know a work around would be to manually adjust the height, but
I
| could find myself in trouble if text were added to those cells.




All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com