Text upside down!
 

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

Text upside down!
 

Have a look at this post

http://groups.google.co.uk/group/mic...e627c7f 2b5c6

HTH

Keith

Text upside down!
 

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.



wrote:

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

--

Dave Peterson

Text upside down!
 

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

Text upside down!
 

Maybe you could use WordArt instead?

In xl2003:
Insert|Picture|WordArt

It may look prettier.

wrote:

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