#1   Report Post  
Dan
 
Posts: n/a
Default 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.
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic coloring of blank cells when sheet work complete bigdaddy3 Excel Worksheet Functions 14 August 5th 05 05:00 PM
auto color blank cells ,best solution bigdaddy3 Excel Discussion (Misc queries) 1 August 3rd 05 05:21 PM
How can I make the graph omit blank cells in the data set? easy Charts and Charting in Excel 3 March 17th 05 02:48 PM
count non blank cells which meet criteria in another column cmarsh5035 Excel Worksheet Functions 2 February 16th 05 04:32 PM
Automatic copying data excluding blank cells Wesley Excel Worksheet Functions 6 November 30th 04 01:17 AM


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"