Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Text Direction = Vertical, Excel Mis-behaves

Latest post Thu, Mar 11 2010 4:59 PM by Jim Cone. 1 replies.
  • Thu, Mar 11 2010 10:18 AM

    • Ali Kapasi
    • Top 75 Contributor
    • Joined on Wed, Feb 17 2010
    • London
    • Posts 9
    • Points 173

    Text Direction = Vertical, Excel Mis-behaves

    Not sure if this is Excel 'mis-behaving' or just how it 'behaves'.

    Looking at the 'Sample'xls' file you can see Column A is ridiculously wide.  This has been auto-adjusted, but it seems that because the text in the column is at 90 degrees (or -90 degress) orientation, it is somehow causing the column auto-adjust to behave this way.  When the text is at normal 0 degrees, the auto-adjust works fine.

    This isn't a major issue that will keep me awake at night, just more of a query amongst fellow Excel users.

    Thanks.

    • Post Points: 21
  • Thu, Mar 11 2010 4:59 PM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 119
    • Points 1,632

    Re: Text Direction = Vertical, Excel Mis-behaves

    Merged cells don't respond like normal cells.

    Unmerge and try again.

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.