Results 1 to 10 of 10
  1. #1
    Senior Member Strommer's Avatar
    Join Date
    Dec 2004
    Location
    Masterton
    Posts
    3,847

    Question Excel - text at top, not bottom of a cell

    Within a cell (a paragraph area of merged columns, about 3 cm height) when I start typing text, the text appears at the bottom of the cell. How do I get it to start back up at the top?
    .
    .

    The whole problem with the world is that fools and fanatics
    are always so certain of themselves, but wiser people so full of doubts.

    ~ Bertrand Russell

  2. #2
    Senior Member pctek's Avatar
    Join Date
    Feb 2005
    Location
    In the Wild West
    Posts
    24,212

    Default Re: Excel - text at top, not bottom of a cell

    Alignment. Format - cells, Alignment, change Vertical to top.

  3. #3
    Senior Member Strommer's Avatar
    Join Date
    Dec 2004
    Location
    Masterton
    Posts
    3,847

    Default Re: Excel - text at top, not bottom of a cell

    Quote Originally Posted by pctek View Post
    Alignment. Format - cells, Alignment, change Vertical to top.
    Thanks for QUICK reply, but there is no Alignment tab under the Format menu. Excel Help says that there should be an Alignment tab, but: [Format > Cells] only brings up a Font tab.

    I am using Excel 2002.
    .
    .

    The whole problem with the world is that fools and fanatics
    are always so certain of themselves, but wiser people so full of doubts.

    ~ Bertrand Russell

  4. #4
    Senior Member Strommer's Avatar
    Join Date
    Dec 2004
    Location
    Masterton
    Posts
    3,847

    Default Re: Excel - text at top, not bottom of a cell

    Screenshot showing that Alignment Tab is not present, also shows text at bottom of cell.
    http://www.imagef1.net.nz/files/Excel.jpg
    .
    .

    The whole problem with the world is that fools and fanatics
    are always so certain of themselves, but wiser people so full of doubts.

    ~ Bertrand Russell

  5. #5
    Bleakly Optomistic
    Join Date
    Jun 2006
    Location
    Otaki, NZ
    Posts
    1,467

    Default Re: Excel - text at top, not bottom of a cell

    You'll have to do that when the cell(s) are not active. (e.g halfway through typing)

  6. #6
    Senior Member Strommer's Avatar
    Join Date
    Dec 2004
    Location
    Masterton
    Posts
    3,847

    Default Re: Excel - text at top, not bottom of a cell

    Quote Originally Posted by the_bogan View Post
    You'll have to do that when the cell(s) are not active. (e.g halfway through typing)
    Thanks - that did it. Dunno - thought I tried the inactive option but guess not.

    Here is another simple question:
    How do I close this cell that has a missing vertical line (see screenshot, the cell has a missing boundary on the right side).
    http://www.imagef1.net.nz/files/Excel_2.jpg
    .
    .

    The whole problem with the world is that fools and fanatics
    are always so certain of themselves, but wiser people so full of doubts.

    ~ Bertrand Russell

  7. #7
    Bleakly Optomistic
    Join Date
    Jun 2006
    Location
    Otaki, NZ
    Posts
    1,467

    Default Re: Excel - text at top, not bottom of a cell

    Try playing with the border tab in format Cells. (CTRL 1 to get there quickly)

  8. #8
    Senior Member Strommer's Avatar
    Join Date
    Dec 2004
    Location
    Masterton
    Posts
    3,847

    Thumbs up Re: Excel - text at top, not bottom of a cell

    Quote Originally Posted by the_bogan View Post
    Try playing with the border tab in format Cells. (CTRL 1 to get there quickly)
    Thanks again !
    .
    .

    The whole problem with the world is that fools and fanatics
    are always so certain of themselves, but wiser people so full of doubts.

    ~ Bertrand Russell

  9. #9
    Senior Member pctek's Avatar
    Join Date
    Feb 2005
    Location
    In the Wild West
    Posts
    24,212

    Default Re: Excel - text at top, not bottom of a cell

    Quote Originally Posted by Steve_L View Post
    there is no Alignment tab under the Format menu.
    Alignment. Format - cells, Alignment, change Vertical to top.

  10. #10
    Senior Member Strommer's Avatar
    Join Date
    Dec 2004
    Location
    Masterton
    Posts
    3,847

    Default Re: Excel - text at top, not bottom of a cell

    Quote Originally Posted by pctek View Post
    Alignment. Format - cells, Alignment, change Vertical to top.
    PCT, this did not work. When I tried Format > Cells, there was no Alignment tab - I posted this above, with a screenshot.

    The problem was that the cell had to be inactive, as the_bogan pointed out.
    .
    .

    The whole problem with the world is that fools and fanatics
    are always so certain of themselves, but wiser people so full of doubts.

    ~ Bertrand Russell

Similar Threads

  1. Replies: 1
    Last Post: 07-10-2007, 05:26 PM
  2. Can I bottom-align text in a Word text box?
    By Billy T in forum PressF1
    Replies: 5
    Last Post: 22-05-2004, 12:14 AM
  3. Replies: 5
    Last Post: 24-10-2003, 02:44 PM
  4. Replies: 0
    Last Post: 12-08-2000, 09:33 PM
  5. Replies: 0
    Last Post: 09-08-2000, 08:38 PM

Posting Permissions

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