Results 1 to 4 of 4
  1. #1
    sgrad
    Guest

    vertical text? (excel 97)

    I would like to place text vertically on top of a column, so it is only one character wide, with one letter above one another..i.e. n
    o
    v

    1
    4 I would also like to place it with the letter bottom facing to the right so that the
    text reads across the left side.
    Is there a way to manipulate the text.
    Thanks for the help.
    Steve
    sgrad@bigfoot.com

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vertical text? (excel 97)

    Select the cell(s).
    Hit Format-Cells.
    Click the Alignment tab.
    Set the degrees to 90.
    I'm in Excel 2000, but am 99% sure it's available in 97 also.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: vertical text? (excel 97)

    In the Format, Cells, Alignment dialog, you will see an area called Orientation with a box option showing:

    T
    e
    x
    t

    Select the range you want to have that "vertical stack" alignment, then click that box.

    For the character bottoms to face to the right, in the same Dialog within Orientation, use 90
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vertical text? (excel 97)

    Select the cell where you want the text, then select Cell from the Format menu. Click on the Alignment tab. In the Orientation section enter 90 in the box next to Degrees. You might also want to click on the Number tab and select Text.
    Legare Coleman

Posting Permissions

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