Text formatting in cells

H

HawkeyePierce63

I am designing a form in Excel 2000. Occasionally, in a cell I am getting what appears to be a blank line immediately above the first line of text. I have tried changing alignment & cell format etc, but it still appears every so often & I would like to prevent this. Any help would be appreciated
 
D

Dave Peterson

You get one rowheight per row.

If the cell in Column A needs a large rowheight and the cell in column B (in the
same row) needs just a little height (and you have the cell formatted to be
bottom aligned), it could look this way.

If that's not the case, have you reset the height of that row:
select the row
format|row|autofit
(or double click on the bottom row border in the row headers (to the left of the
worksheet proper).
 
E

Earl Kiosterud

HP,

If you've pressed Alt-Enter, you've put a newline character (like pressing
Enter in most text programs). If the cursor will go to this empty line,
press Delete to clear it.

The row height may have gotten set too large. Try Format - Rows - Autofit.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"[email protected]"
I am designing a form in Excel 2000. Occasionally, in a cell I am getting
Click to expand...
what appears to be a blank line immediately above the first line of text. I
have tried changing alignment & cell format etc, but it still appears every
so often & I would like to prevent this. Any help would be appreciated
 
Top