+ Reply to Thread
Results 1 to 3 of 3

How do I clear blank space at the top of a word-wrapped text cell?

  1. #1
    mirage1210
    Guest

    How do I clear blank space at the top of a word-wrapped text cell?

    Often when I set cells to word-wrap and then auto-fit the row height, cells
    with text will end up with a blank line or two at the top. It's not extra
    spaces in the text because when I go to the formula bar, there's nothing
    before the start of the text. I can manually adjust the size of each row,
    but that's a hassle and not very consistent!

    Thanks.

  2. #2
    Carole O
    Guest

    RE: How do I clear blank space at the top of a word-wrapped text cell?

    In the same Format, Cells, Alignment, select Top in Text Alignment Vertical.

    HTH,

    Carole O

    "mirage1210" wrote:

    > Often when I set cells to word-wrap and then auto-fit the row height, cells
    > with text will end up with a blank line or two at the top. It's not extra
    > spaces in the text because when I go to the formula bar, there's nothing
    > before the start of the text. I can manually adjust the size of each row,
    > but that's a hassle and not very consistent!
    >
    > Thanks.


  3. #3
    mirage1210
    Guest

    RE: How do I clear blank space at the top of a word-wrapped text c

    Thanks, Carole... I did try that, but then it just moves the blank space to
    the *bottom* of the cell. Either way, I end up with a row that's not the
    right height for the contents.

    "Carole O" wrote:

    > In the same Format, Cells, Alignment, select Top in Text Alignment Vertical.
    >
    > HTH,
    >
    > Carole O
    >
    > "mirage1210" wrote:
    >
    > > Often when I set cells to word-wrap and then auto-fit the row height, cells
    > > with text will end up with a blank line or two at the top. It's not extra
    > > spaces in the text because when I go to the formula bar, there's nothing
    > > before the start of the text. I can manually adjust the size of each row,
    > > but that's a hassle and not very consistent!
    > >
    > > Thanks.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1