Text formatting in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).
 
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
-------------------------------------------

"(e-mail address removed)"
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top