A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cell set to wrap text and blank line -- fix?



 
 
Thread Tools Display Modes
  #1  
Old January 25th, 2005, 07:10 PM
Fred Holmes
external usenet poster
 
Posts: n/a
Default Cell set to wrap text and blank line -- fix?

I often find that with a cell set to "wrap text" the cell opens up an
additional line before a charater of inserted text is actually placed
on (wrapped to) the new line. With a certain length of text in the
cell, a blank line appears at the bottom of the cell. (If the cell is
set to vertically align its contentes to "top".)

Short of manually setting the cell height to an explicit fixed value,
is there any way of preventing this behavior? Such that the cell is
always "filled," i.e., no blank line.

I'm using WinXP, SP-2 and Excel 2003, but it has been a problem with
Win2k SP-4 and Excel 2000 as well. I suspect it's a problem with all
versions of Excel.

Is this "too hard" for Microsoft to fix?

Thanks,

Fred Holmes
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unwanted blank line in cell with wrapped text bbl General Discussion 2 February 11th, 2005 09:29 PM
Prevent Blank Records being written. Need Help. Robert Nusz @ DPS Using Forms 4 December 29th, 2004 05:15 PM
How to identify (test) a blank or blank line in a text file? Peter General Discussion 2 August 5th, 2004 03:43 PM
wrap text adds add'l blank line to the row Mark G Worksheet Functions 0 April 26th, 2004 06:41 PM
if statement - text / blank cell jester Worksheet Functions 5 November 3rd, 2003 01:28 AM


All times are GMT +1. The time now is 07:00 AM.


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