Friday, January 22, 2021

#1 2020-08-01 07:17:07 pm

MitchBVI
Member
Registered: 2006-02-14
Posts: 223

Change text Orientation

I have been trying to change the orientation of text in an excel cell.   Not a problem to change vertical to top center or horizontal left right etc But to go from horizontal to vertical has me stumped. Any suggestions appreciated particularly if it’s not possible.

Browser: Safari 605.1.15
Operating System: macOS 10.14

Offline

 

#2 2020-08-15 03:38:05 am

KniazidisR
Member
From:: Greece
Registered: 2019-03-03
Posts: 1549

Re: Change text Orientation

Simply something like that:

Applescript:


tell application "Microsoft Excel"
   tell active workbook to tell active sheet to tell cell "A1"
       set text orientation to -22 -- degrees (can be integer from -90 to 90)
       -- or
       -- set text orientation to orientation vertical -- (can be 1 of 4 predefined constants like this):
       -- (orientation vertical; orientation horizontal; orientation upward; orientation downward)
   end tell
end tell

Last edited by KniazidisR (2020-08-17 10:05:41 am)


Model: MacBook Pro
OS X: Catalina 10.15.4
Web Browser: Safari 13.1
Ram: 4 GB


Filed under: excel, Text orientation

Offline

 

#3 2020-08-21 01:02:33 pm

MitchBVI
Member
Registered: 2006-02-14
Posts: 223

Re: Change text Orientation

My apologies in taking so long to acknowledge your solution and thank you for taking the time. I had taken to creating templates to solve the issue this is far better.

Offline

 

Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)