Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Text upside down!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
stevewy@hotmail.com - 22 Jan 2008 10:09 GMT
I'm designing a basic wall planner in Excel, and due to the way it is
laid out I really need to have text in certain cells displaying upside
down.  At least, the text will be upside down in Excel - once the
planner is printed out and displayed correctly, the text should run
upwards when you are reading it.

It is easy to rotate text in a cell minus 90 degrees to plus 90
degrees from the horizontal, but I cannot find any way to rotate it a
full 180 degrees so it looks upside down.  There are quite a few cells
to be done in this way.

Is there any way I can do this, apart from saving off the ordinary
cells, pasting them into Word as a Picture, rotating them 180 degrees
then pasting them back?  This is one method of 180 degree rotation I
have tried before, but given the amount of this there is to do, I
wondered if there was an easier way....

Any help would be appreciated!

Steve Wylie
Kent
UK
Keith74 - 22 Jan 2008 16:38 GMT
Have a look at this post

http://groups.google.co.uk/group/microsoft.public.excel.misc/browse_thread/threa
d/e19dbdd3a5bcc36b/373ce627c7f2b5c6?lnk=gst&q=invert+text#373ce627c7f2b5c6


HTH

Keith
Dave Peterson - 22 Jan 2008 16:40 GMT
You can paste as a picture within excel.

Type your string in a cell (a different worksheet???)
Edit|copy that cell

Select the destination cell
shift-edit|paste picture link
and rotate the picture the way you like

It's never looked as nice as I hoped for me.

But pasting as picture link means that you can modify the "sending" cell and the
picture will change.

> I'm designing a basic wall planner in Excel, and due to the way it is
> laid out I really need to have text in certain cells displaying upside
[quoted text clipped - 18 lines]
> Kent
> UK

Signature

Dave Peterson

stevewy@hotmail.com - 22 Jan 2008 17:03 GMT
Thank you for your responses.  It is as I thought - although the
slight tweak of inserting as a link rather than embedded picture will
at least help if, as you say, the content changes.

Steve
Dave Peterson - 22 Jan 2008 18:33 GMT
Maybe you could use WordArt instead?

In xl2003:
Insert|Picture|WordArt

It may look prettier.

> Thank you for your responses.  It is as I thought - although the
> slight tweak of inserting as a link rather than embedded picture will
> at least help if, as you say, the content changes.
>
> Steve

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.